Databases

SQL, NoSQL, schema design, migrations, ORMs, and database operations

skills in category: 4,314
pages available: 180

Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.

Open in full browser

Browse databases skills

Showing 4,081–4,104 of 4,314 skills

Managing Database ReplicationAProcess use when you need to work with database scalability. This skill provides replication and sharding with comprehensive guidance and automation. Trigger with phrases like "set up replication", "implement sharding", or "scale database".databasesgobashVotes: 0GitHub stars: 2,688
Managing Database RecoveryAProcess use when you need to work with database operations. This skill provides database management and optimization with comprehensive guidance and automation. Trigger with phrases like "manage database", "optimize database", or "configure database".databasesgobashVotes: 0GitHub stars: 2,688
Managing Database PartitionsAProcess use when you need to work with database partitioning. This skill provides table partitioning strategies with comprehensive guidance and automation. Trigger with phrases like "partition tables", "implement partitioning", or "optimize large tables".databasesgobashVotes: 0GitHub stars: 2,688
Managing Database MigrationsAProcess use when you need to work with database migrations. This skill provides schema migration management with comprehensive guidance and automation. Trigger with phrases like "create migration", "run migrations", or "manage schema versions".databasesgobashVotes: 0GitHub stars: 2,688
Analyzing Database IndexesAProcess use when you need to work with database indexing. This skill provides index design and optimization with comprehensive guidance and automation. Trigger with phrases like "create indexes", "optimize indexes", or "improve query performance".databasesgobashVotes: 0GitHub stars: 2,688
Comparing Database SchemasAProcess use when you need to work with schema comparison. This skill provides database schema diff and sync with comprehensive guidance and automation. Trigger with phrases like "compare schemas", "diff databases", or "sync database schemas".databasesgobashVotes: 0GitHub stars: 2,688
Detecting Database DeadlocksAProcess use when you need to work with deadlock detection. This skill provides deadlock detection and resolution with comprehensive guidance and automation. Trigger with phrases like "detect deadlocks", "resolve deadlocks", or "prevent deadlocks".databasesgobashVotes: 0GitHub stars: 2,688
Optimizing Database Connection PoolingAProcess use when you need to work with connection management. This skill provides connection pooling and management with comprehensive guidance and automation. Trigger with phrases like "manage connections", "configure pooling", or "optimize connection usage".databasesgobashVotes: 0GitHub stars: 2,688
Implementing Database CachingAProcess use when you need to implement multi-tier caching to improve database performance. This skill sets up Redis, in-memory caching, and CDN layers to reduce database load. Trigger with phrases like "implement database caching", "add Redis cache layer", "improve query performance with caching", or "reduce database load".databasespythonjavaVotes: 0GitHub stars: 2,688
Implementing Database Audit LoggingAProcess use when you need to track database changes for compliance and security monitoring. This skill implements audit logging using triggers, application-level logging, CDC, or native logs. Trigger with phrases like "implement database audit logging", "add audit trails", "track database changes", or "monitor database activity for compliance".databasesbashsqlVotes: 0GitHub stars: 2,688
Archiving DatabasesAProcess use when you need to archive historical database records to reduce primary database size. This skill automates moving old data to archive tables or cold storage (S3, Azure Blob, GCS). Trigger with phrases like "archive old database records", "implement data retention policy", "move historical data to cold storage", or "reduce database size with archival".databasesshellbashVotes: 0GitHub stars: 2,688
Validating Database IntegrityAProcess use when you need to ensure database integrity through comprehensive data validation. This skill validates data types, ranges, formats, referential integrity, and business rules. Trigger with phrases like "validate database data", "implement data validation rules", "enforce data integrity constraints", or "validate data formats".databasesbashsqlVotes: 0GitHub stars: 2,688
Generating Database Seed DataAProcess this skill enables AI assistant to generate realistic test data and database seed scripts for development and testing environments. it uses faker libraries to create realistic data, maintains relational integrity, and allows configurable data volumes. u... Use when working with databases or data models. Trigger with phrases like 'database', 'query', or 'schema'.databasesjavascriptjavaVotes: 0GitHub stars: 2,688
Firestore Operations ManagerAManage Firebase/Firestore operations including CRUD, queries, batch processing, and index/rule guidance. Use when you need to create/update/query Firestore documents, run batch writes, troubleshoot missing indexes, or plan migrations. Trigger with phrases like "firestore operations", "create firestore document", "batch write", "missing index", or "fix firestore query".databasesgobashVotes: 0GitHub stars: 2,688
Sql ExpertAWrite, optimize, and debug T-SQL queries for Microsoft SQL Server. Covers CTEs, window functions, PIVOT, MERGE, APPLY operators, execution plan analysis, indexing strategies, and stored procedures. Use when working with SQL Server, T-SQL scripts, .sql files, stored procedures, query optimization, or database performance tuning.databasesgosqlVotes: 0GitHub stars: 416
Datafusion Query AdvisorAReviews SQL queries and DataFrame operations for optimization opportunities including predicate pushdown, partition pruning, column projection, and join ordering. Activates when users write DataFusion queries or experience slow query performance.databasesrustgoVotes: 0GitHub stars: 416
Sql Injection QueryAQuery database safely with parameterized statementsdatabasespythondatabaseVotes: 0GitHub stars: 665
Allra Database SchemaAAllra 데이터베이스 설계 및 QueryDSL 사용 규칙. Use when creating JPA entities, writing QueryDSL queries, or adding @Transactional annotations.databasesgojavaVotes: 0GitHub stars: 416
Surrealdb PythonAMaster SurrealDB 2.3.x with Python for multi-model database operations including CRUD, graph relationships, vector search, and real-time queries. Use when working with SurrealDB databases, implementing graph traversal, semantic search with embeddings, or building RAG applications.databasespythonnodeVotes: 0GitHub stars: 416
ArbiterBPush decisions to Arbiter Zebu for async human review. Use when you need human input on plans, architectural choices, or approval before proceeding.databasesgobashVotes: 0GitHub stars: 665
PostgresAPostgreSQL database management. Run queries, manage schemas, and monitor performance.databasesbashsqlVotes: 0GitHub stars: 665
DatabaseADatabase management and queries. Connect to SQL and NoSQL databases, run queries, and manage schemas.databasesgosqlVotes: 0GitHub stars: 665
NotionBNotion API for creating and managing pages, databases, and blocks.databasesbashapiVotes: 0GitHub stars: 207
Backend StandardsAUse when implementing or refactoring backend logic in packages/api or packages/db. Enforce router/service/data access layering, naming conventions, TRPC best practices, and Drizzle schema guidelines.databasesrefactoringapiVotes: 0GitHub stars: 207