🗄️SQL and Databases Skills
Browse the best SQL and Databases skills for Claude Code, Codex, Cursor and other AI agents.
1,171 skills · Page 19 of 49
setup-mongodb
★ 1Configure MongoDB connection and test infrastructure. Use when adding MongoDB support to the project. Triggers on "setup mongodb", "add mongodb", "configure database", "mongodb connection".
moai-platform-neon
★ 1Neon serverless PostgreSQL specialist covering auto-scaling, database branching, PITR, and connection pooling. Use when building serverless apps needing PostgreSQL, implementing preview environments, or optimizing database costs.
backend-migrations
★ 1Create and manage database migrations following best practices for safe schema evolution. Use this skill when creating new database migration files for schema changes. Use this skill when modifying table structures, adding or removing columns, or changing data types. Use this skill when creating or modifying database indexes. Use this skill when implementing reversible migrations with up/down or rollback methods. Use this skill when working with migration files in database change management directories. Use this skill when planning zero-downtime deployments or backwards-compatible schema changes. Use this skill when separating schema changes from data migrations.
backend-queries
★ 1Write secure, performant database queries following best practices for data retrieval and manipulation. Use this skill when writing SQL queries, ORM query methods, or database query builders. Use this skill when fetching data with joins, filters, or complex query conditions. Use this skill when implementing eager loading to prevent N+1 query problems. Use this skill when optimizing query performance with proper indexing strategies. Use this skill when writing parameterized queries to prevent SQL injection. Use this skill when implementing database transactions for related operations. Use this skill when working with query optimization, caching strategies, or query timeout handling.
backend-models
★ 1Define and structure database models and entities following data modeling best practices. Use this skill when creating or modifying model classes, entities, or database schema definitions. Use this skill when defining model relationships, associations, or foreign keys. Use this skill when implementing model validations, constraints, or data integrity rules. Use this skill when adding timestamps, indexes, or database-level constraints to models. Use this skill when choosing appropriate data types for model attributes. Use this skill when working with ORM model files, entity definitions, or database schema classes. Use this skill when establishing naming conventions for models and database tables.
implementing-database-audit-logging
★ 1Use 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".
duckdb-temporal-versioning
★ 1Temporal versioning and interaction history with time-travel queries,
redis
★ 1Redis DBA skill for cache/data-structure design, performance tuning, memory optimization, persistence (RDB/AOF), replication/cluster, high availability (Sentinel), and operational troubleshooting. Use for tasks like diagnosing latency spikes, eviction issues, hot keys, and designing safe cache patterns.
lang-cypher-dev
★ 1Foundational Cypher (Neo4j) patterns covering graph pattern matching, MATCH/CREATE/MERGE/DELETE operations, relationships, path patterns, aggregation, filtering, and common graph query patterns. Use when writing Cypher queries, modeling graph data, or needing guidance on graph database operations. This is the entry point for Cypher development.
comparing-database-schemas
★ 1Use 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".
database-workflows
★ 1Database workflows - schema design, migrations, query optimization. Use when designing schemas, reviewing migrations, optimizing queries, preventing N+1 problems, or working with ORMs like Prisma, Drizzle, and TypeORM.
openmetadata-user
★ 1Use OpenMetadata UI for data discovery, governance, and collaboration. Use when searching for data assets, managing descriptions and ownership, creating glossary terms, setting up data contracts, or tracking data insights and KPIs.
automating-database-backups
★ 1Use when you need to automate database backup processes with scheduling and encryption.This skill creates backup scripts for PostgreSQL, MySQL, MongoDB, and SQLite with compression.Trigger with phrases like "automate database backups", "schedule database dumps","create backup scripts", or "implement disaster recovery for database".
elasticsearch
★ 1Elasticsearch DBA skill for index/mapping design, query tuning, cluster sizing and operations, shard/replica strategy, ILM, monitoring, troubleshooting (hot nodes, GC, rejected requests), and safe reindexing/upgrades. Use for tasks like designing search schemas, diagnosing performance issues, and operating ES in production.
archiving-databases
★ 1Use 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".
analyzing-database-indexes
★ 1Use 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".
optimizing-sql-queries
★ 1Use when you need to work with query optimization.This skill provides query performance analysis with comprehensive guidance and automation.Trigger with phrases like "optimize queries", "analyze performance",or "improve query speed".
duck-time-travel
★ 1DuckDB time-travel queries for temporal versioning and causality tracking
managing-database-partitions
★ 1Use 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".
designing-database-schemas
★ 1Use when you need to work with database schema design.This skill provides schema design and migrations with comprehensive guidance and automation.Trigger with phrases like "design schema", "create migration",or "model database".
optimizing-database-connection-pooling
★ 1Use 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".
dune-analytics
★ 1Query Dune Analytics API for blockchain data, pyUSD flows, stablecoin metrics, and on-chain analytics. Use when analyzing DeFi protocols, token flows, or building dashboards.
managing-database-sharding
★ 1Use when you need to work with database sharding.This skill provides horizontal sharding strategies with comprehensive guidance and automation.Trigger with phrases like "implement sharding", "shard database",or "distribute data".
managing-database-migrations
★ 1Use 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".