Databases
89 skills
sql-optimization-patterns
wshobson/agentsMaster SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
discover-database
rand/cc-polymathAutomatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection. Activates for database design, optimization, and implementation tasks.
query-builder
CuriousLearner/devkitInteractive database query builder for generating optimized SQL and NoSQL queries.
database-architect
marcioaltoe/claude-craftkitExpert database schema designer and Drizzle ORM specialist. Use when user needs database design, schema creation, migrations, query optimization, or Postgres-specific features. Examples - "design a database schema for users", "create a Drizzle table for products", "help with database relationships", "optimize this query", "add indexes to improve performance", "design database for multi-tenant app".
database-monitoring
aj-geddes/useful-ai-promptsMonitor database performance and health. Use when setting up monitoring, analyzing metrics, or troubleshooting database issues.
database-schema-designer
ArieGoldkin/ai-agent-hubUse this skill when designing database schemas for relational (SQL) or document (NoSQL) databases. Provides normalization guidelines, indexing strategies, migration patterns, and performance optimization techniques. Ensures scalable, maintainable, and performant data models.
database-migration
wshobson/agentsExecute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
databases
mrgoonie/claudekit-skillsWork with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queries and aggregations, optimizing indexes for performance, performing database migrations, configuring replication and sharding, implementing backup and restore strategies, managing database users and permissions, analyzing query performance, or administering production databases.
wheels-migration-generator
wheels-dev/wheelsGenerate database-agnostic Wheels migrations for creating tables, altering schemas, and managing database changes. Use when creating or modifying database schema, adding tables, columns, indexes, or foreign keys. Prevents database-specific SQL and ensures cross-database compatibility.
wheels-migration-generator
wheels-dev/wheelsGenerate database-agnostic Wheels migrations for creating tables, altering schemas, and managing database changes. Use when creating or modifying database schema, adding tables, columns, indexes, or foreign keys. Prevents database-specific SQL and ensures cross-database compatibility.
database-implementation
jpicklyk/task-orchestratorDatabase schema design, migrations, query optimization with SQL, Exposed ORM, Flyway. Use for database, migration, schema, sql, flyway tags. Provides migration patterns, validation commands, rollback strategies.
backend-migrations
maxritter/claude-codeproCreate and manage database migrations with reversible changes, proper naming conventions, and zero-downtime deployment strategies. Use this skill when creating database migration files, modifying schema, adding or removing tables/columns, managing indexes, or handling data migrations. Apply when working with migration files (e.g., db/migrate/, migrations/, alembic/, sequelize migrations), schema changes, database versioning, rollback implementations, or when you need to ensure backwards compatibility during deployments. Use for any task involving database structure changes, index creation, constraint modifications, or data transformation scripts.
backend-queries
maxritter/claude-codeproWrite secure, optimized database queries using parameterized queries, eager loading to prevent N+1 problems, and strategic indexing for performance. Use this skill when writing SQL queries, ORM queries, database interactions, or optimizing data fetching logic. Apply when working with query files, repository patterns, data access layers, SQL statements, ORM methods (ActiveRecord, Sequelize, Prisma queries), JOIN operations, WHERE clauses, preventing SQL injection, implementing eager loading or includes, adding query timeouts, wrapping operations in transactions, or caching expensive queries. Use for any task involving database reads, writes, complex queries, query optimization, or data fetching performance.
rr-drizzle
roderik/ai-rulesComprehensive guidance for implementing type-safe database operations with Drizzle ORM and PostgreSQL. Use when working with database schemas, queries, migrations, or performance optimization in TypeScript applications. Automatically triggered when working with Drizzle schema files, database queries, or PostgreSQL operations.
dbt-performance
sfc-gh-dflippo/snowflake-dbt-demoOptimizing dbt and Snowflake performance through materialization choices, clustering keys, warehouse sizing, and query optimization. Use this skill when addressing slow model builds, optimizing query performance, sizing warehouses, implementing clustering strategies, or troubleshooting performance issues.
grey-haven-database-conventions
greyhaven-ai/claude-code-config"Apply Grey Haven database conventions - snake_case fields, multi-tenant with tenant_id and RLS, proper indexing, migrations for Drizzle (TypeScript) and SQLModel (Python). Use when designing schemas, writing database code, creating migrations, setting up RLS policies, or when user mentions 'database', 'schema', 'Drizzle', 'SQLModel', 'migration', 'RLS', 'tenant_id', 'snake_case', 'indexes', or 'foreign keys'."
cocoindex
cocoindex-io/cocoindex-claudeComprehensive toolkit for developing with the CocoIndex library. Use when users need to create data transformation pipelines (flows), write custom functions, or operate flows via CLI or API. Covers building ETL workflows for AI data processing, including embedding documents into vector databases, building knowledge graphs, creating search indexes, or processing data streams with incremental updates.
query-optimizer
CuriousLearner/devkitAnalyze and optimize SQL queries for better performance and efficiency.
backend-migrations
coreyja/coreyjaCreate and manage database migrations with proper rollback methods, focused changes, and zero-downtime deployment considerations. Use this skill when creating new database migration files, modifying table schemas, adding or removing columns, creating or dropping indexes, or managing database version control. When working with migration directories, schema definition files, or database change scripts. When implementing backwards-compatible database changes for production deployments. When separating schema changes from data migrations.
aws-rds-database
aj-geddes/useful-ai-promptsDeploy and manage relational databases using RDS with Multi-AZ, read replicas, backups, and encryption. Use for PostgreSQL, MySQL, MariaDB, and Oracle.
data-migration-scripts
aj-geddes/useful-ai-promptsCreate safe, reversible database migration scripts with rollback capabilities, data validation, and zero-downtime deployments. Use when changing database schemas, migrating data between systems, or performing large-scale data transformations.
database-migration-management
aj-geddes/useful-ai-promptsManage database migrations and schema versioning. Use when planning migrations, version control, rollback strategies, or data transformations in PostgreSQL and MySQL.
database-query-optimization
aj-geddes/useful-ai-promptsImprove database query performance through indexing, query optimization, and execution plan analysis. Reduce response times and database load.
nosql-database-design
aj-geddes/useful-ai-promptsDesign NoSQL database schemas for MongoDB and DynamoDB. Use when modeling document structures, designing collections, or planning NoSQL data architectures.
sql-query-optimization
aj-geddes/useful-ai-promptsAnalyze and optimize SQL queries for performance. Use when improving slow queries, reducing execution time, or analyzing query performance in PostgreSQL and MySQL.
database-design
akaszubski/autonomous-devDatabase schema design, migrations, query optimization, and ORM patterns. Use when designing database schemas, writing migrations, optimizing queries, or working with ORMs like SQLAlchemy or Django ORM.
brokle-migration-workflow
brokle-ai/brokleUse this skill when creating, running, or managing database migrations for PostgreSQL or ClickHouse. This includes creating new migrations, running migrations, checking migration status, rollback operations, seeding data, or troubleshooting migration issues.
sql-cli
Interstellar-code/claud-skillsToken-efficient MySQL/PostgreSQL operations using mycli and native CLI tools (Windows/Mac/Linux compatible). Replaces Artisan Tinker for database queries with 87% token savings.
moai-domain-database
modu-ai/moai-adkDatabase design, schema optimization, indexing strategies, and migration management.
postgresql-migrations-expert
pr-pm/prpmComprehensive guide to PostgreSQL migrations - common errors, generated columns, full-text search, indexes, idempotent migrations, and best practices for database schema changes
database
rubys/showcaseDatabase management commands and the bin/run utility for executing Ruby scripts against specific event databases. Use when the user needs to query, manipulate, or run scripts against existing databases without starting a Rails server.
migration-generator
CuriousLearner/devkitCreate database migrations from model changes, schema diffs, and migration best practices.
alembic
manutej/luxor-claude-marketplaceComprehensive Alembic database migration management for customer support systems
backend-queries
coreyja/coreyjaWrite secure, performant database queries using parameterized statements, proper indexing, and query optimization techniques. Use this skill when writing SQL queries, ORM query methods, or database access code. When implementing data fetching logic that retrieves or updates database records. When optimizing queries to prevent N+1 problems through eager loading or joins. When using WHERE clauses, JOIN operations, or ORDER BY statements. When implementing transactions for related database operations. When working with query builder methods, raw SQL, or ORM query interfaces. When setting query timeouts or implementing query result caching.
data-replication-setup
aj-geddes/useful-ai-promptsSet up database replication for high availability and disaster recovery. Use when configuring master-slave replication, multi-master setups, or replication monitoring.
database-performance-debugging
aj-geddes/useful-ai-promptsDebug database performance issues through query analysis, index optimization, and execution plan review. Identify and fix slow queries.
migration-patterns
spences10/devhub-crmDatabase migration patterns for SQLite. Use when creating migrations, modifying schema, or running database changes.
managing-supabase-schema-migrations
lifegenieai/claude-skillsGuides creation, validation, and application of Supabase database migrations with RLS policy checks and type generation. Use when adding tables, modifying schema, or updating database structure.
database-optimization-guru
sandraschi/advanced-memory-mcpDatabase expert for query optimization, indexing, schema design, and
sql-expert
AutumnsGrove/ClaudeSkills"Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server. Use when working with databases for: (1) Writing complex SQL queries with joins, subqueries, and window functions, (2) Optimizing slow queries and analyzing execution plans, (3) Designing database schemas with proper normalization, (4) Creating indexes and improving query performance, (5) Writing migrations and handling schema changes, (6) Debugging SQL errors and query issues"
query-optimization
cyperx84/claude-code-plugin-examples"Techniques for optimizing database queries, indexing strategies, and performance tuning for SQL databases"
prisma-query-optimizer
databayt/hogwartsQuery optimization and N+1 detection
database-query-optimizer
Dexploarer/claudius-skillsAnalyzes and optimizes database queries for PostgreSQL, MySQL, MongoDB with EXPLAIN plans, index suggestions, and N+1 query detection. Use when user asks to "optimize query", "analyze EXPLAIN plan", "fix slow queries", or "suggest database indexes".
postgres-manager
AlexBaum-ai/NEURMManage PostgreSQL databases using Postgres MCP. Query data, inspect schemas, analyze table structures, run migrations, debug database issues, and manage test data. Use when working with databases, debugging queries, or validating data integrity.
supabase-migration
amo-tech-ai/medellin-sparkSafe database migration creation and management for Supabase PostgreSQL
supabase-migration
amo-tech-ai/skybox-gamehubSafe database migration creation and management for Supabase PostgreSQL
migration-validator
ComparePower/payload-cms-cloudflare-baselineVerify migration results at all layers - database queries, field presence checks, relationship integrity, admin UI testing with Playwright, and comprehensive validation reporting. Use when validating migrations, verifying database seeding, checking data integrity, testing admin UI functionality, generating validation reports, or confirming migration success.
sql-development
dasien/RemoteCredentialRequestPOC"Design efficient database schemas, write optimized queries with proper indexes, and manage data operations following best practices"
tokenmilagre-database
dogespartano-cyber/tokenmilagre-platformThis skill guides database management including Prisma schema design, migrations, data modeling, query optimization, and database maintenance. Use when modifying the database schema, creating migrations, optimizing queries, or troubleshooting database issues.
database-setup
dogespartano-cyber/tokenmilagre-platformUse this skill when working with database, Prisma ORM, PostgreSQL, Server Components, deployment issues, or build configuration. Contains critical rules for data access, migrations, and Vercel builds.
backend-migrations
EIS-ITS/vss-cliCreate and manage database schema migrations with reversibility, zero-downtime deployment support, and proper version control. Use this skill when creating database migration files, modifying schema, adding or removing tables/columns, creating indexes, managing migration rollbacks, or planning database changes. Apply when working with migration files, schema changes, database versioning, or any task involving evolving database structure over time while maintaining backwards compatibility and data integrity.
backend-queries
EIS-ITS/vss-cliWrite secure, optimized database queries using parameterized statements, eager loading, proper indexing, and transaction management. Use this skill when writing database queries, implementing data fetching logic, optimizing query performance, preventing SQL injection, handling N+1 query problems, using ORMs or query builders, implementing caching strategies, or managing database transactions. Apply when working with SQL queries, ORM query methods, database repository patterns, or any code that retrieves or manipulates data from databases.
supabase-operations
elevanaltd/eav-cep-assistSupabase operational knowledge for migrations, RLS optimization, MCP tool benchmarks, and ADR-003 compliance. Use when validating database migrations, optimizing Row-Level Security policies, checking MCP tool performance, or ensuring Supabase operational standards. Triggers on: migration validation, RLS patterns, Supabase benchmarks, ADR-003, database state tracking, schema governance.
supabase-operations
elevanaltd/eav-monorepoSupabase operational knowledge enforcing safety checks via PreToolUse hooks. Provides migration validation, RLS optimization, MCP tool benchmarks, and ADR-003 compliance. Use when migration blocked by safety hooks, validating database migrations, optimizing Row-Level Security policies, checking MCP tool performance, or ensuring Supabase operational standards. Triggers on: migration blocked, safety hook error, migration validation, RLS patterns, Supabase benchmarks, ADR-003, database state tracking, schema governance.
database-backup-restore
fattits30-dev/Justice-Companion"Automated SQLite database backup/restore system with validation, encryption, and migration safety. Supports point-in-time recovery, incremental backups, and disaster recovery. Use before risky operations, data migrations, or production deployments."
database-migration
fattits30-dev/Justice-Companion"Database migration management for Justice Companion using Drizzle ORM: creates migrations, handles rollbacks, validates schema changes, and manages encryption on 11 fields. Use when modifying database schema, adding tables, or troubleshooting migration errors."
supabase-expert-skill
fercracix33/poli2-clean-architectureComplete workflow for implementing data services and database architecture after the Implementer Agent has completed use cases. Provides rigorous step-by-step processes for making data service tests pass through pure database implementations, RLS policy optimization, and schema design. Use when implementing data layer, configuring Row Level Security, designing database schemas, or optimizing query performance. Mandatory Context7 consultation for latest Supabase best practices.
backend-migrations
FlorianRiquelme/statamic-assetsCreate database migrations following Laravel best practices with reversible up/down methods, focused single-purpose changes, proper index management, and clear naming conventions. Use this skill when creating new database tables, adding or modifying columns in existing tables, creating or dropping indexes, implementing foreign key constraints, renaming tables or columns, or managing database schema changes. This skill applies when working on migration files in database/migrations/ directory, generating new migrations via artisan commands, or ensuring zero-downtime deployments with backwards-compatible schema changes.
backend-migrations
grimmolf/mga-soap-calculatorCreate and manage database schema changes through versioned migration files with proper rollback support, zero-downtime deployment considerations, and backwards compatibility. Use this skill when creating migration files, modifying database schemas, adding/removing tables or columns, creating indexes, or working in migration directories. Applies to files like migrations/, alembic/, db/migrate/, schema changes, or any database evolution task requiring versioned, reversible changes that maintain data integrity during deployments.
backend-queries
grimmolf/mga-soap-calculatorWrite secure, performant database queries using parameterized statements, proper indexing, eager loading, and transaction management to prevent SQL injection and N+1 query problems. Use this skill when writing database queries, constructing SQL statements, using ORM query builders, optimizing database performance, or working with repositories, services, or DAO files that interact with databases. Applies to SELECT, INSERT, UPDATE, DELETE operations, joins, aggregations, and any code that retrieves or manipulates data from databases.
database-backup
Hieubkav/wincellarCloneBackendSafe database migration workflow with Spatie backup integration. Always backup before migration, update mermaid.rb schema, keep max 10 recent backups. USE WHEN creating migrations, running migrations, restoring database, managing schema changes, or any risky database operations.
supabase-prisma-database-management
hopeoverture/worldbuilding-app-skillsThis skill should be used when managing database schema, migrations, and seed data using Prisma ORM with Supabase PostgreSQL. Apply when setting up Prisma with Supabase, creating migrations, seeding data, configuring shadow database for migration preview, adding schema validation to CI, or managing database changes across environments.
databases
htlabs-xyz/htlabsWork with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queries and aggregations, optimizing indexes for performance, performing database migrations, configuring replication and sharding, implementing backup and restore strategies, managing database users and permissions, analyzing query performance, or administering production databases.
database-integration
Ingramml/racial-terror-mapDatabase integration patterns for SQL and NoSQL databases. Use when working with database schemas, queries, migrations, or ORM configurations. Supports PostgreSQL, BigQuery, MongoDB, MySQL with progressive disclosure.
dataflow
Integrum-Global/new_project_template"Kailash DataFlow - zero-config database framework with automatic model-to-node generation. Use when asking about 'database operations', 'DataFlow', 'database models', 'CRUD operations', 'bulk operations', 'database queries', 'database migrations', 'multi-tenancy', 'multi-instance', 'database transactions', 'PostgreSQL', 'MySQL', 'SQLite', 'MongoDB', 'pgvector', 'vector search', 'document database', 'RAG', 'semantic search', 'existing database', 'database performance', 'database deployment', 'database testing', or 'TDD with databases'. DataFlow is NOT an ORM - it generates 11 workflow nodes per SQL model, 8 nodes for MongoDB, and 3 nodes for vector operations."
supabase-expert
JKKN-Institutions/KenavoThis skill should be used when working with Supabase database operations in the MyJKKN project, including creating modules, updating schemas, writing RLS policies, creating database functions, implementing Auth SSR, or developing Edge Functions. Automatically triggers when user mentions 'database', 'table', 'SQL', 'Supabase', 'migration', 'RLS', 'policy', or 'Edge Function'.
prisma-patterns
mcgilly17/nix-configsSchema design, migrations, query optimization
env-switch
mim1012/ykp_projectSafely switch between local and production environments with validation and step-by-step guidance. Use when user wants to "switch to local", "change to production", "separate environments", or "toggle between databases". Prevents accidental production data access.
ecto-migration-helper
mkreyman/bmad-elixirCreate, manage, and safely run Ecto database migrations with proper rollback handling and best practices. Use when working with database schema changes, adding columns, or modifying constraints.
sql-optimization-patterns
neo-picasso-2112/dotfilesMaster SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
database
nera0875/BUILDERPostgreSQL VPS database expert. Manages database creation, Prisma schemas, migrations, seeding. Auto-activates on keywords "database", "postgresql", "prisma", "db", "sql" or when backend with data storage needed.
optimize-queries
rdimascio/supabase-marketplaceAutomatically optimize Supabase PostgreSQL queries by analyzing execution plans, adding indexes, and improving RLS policies. Triggers when user mentions slow queries, performance issues, or query optimization.
backend-migrations
Software-Design-Club/todo-appCreate and manage database migrations with reversible changes, zero-downtime deployments, and proper version control practices. Use this skill when creating database migration files, schema change scripts, or any files that modify database structure. Use this when writing migration files with up/down methods, implementing rollback strategies, creating or modifying database tables, adding or removing columns, creating indexes, or handling data migrations separately from schema changes. Use this when working on files in migration directories like db/migrate/, migrations/, or database/migrations/, or when modifying schema definition files.
backend-queries
Software-Design-Club/todo-appWrite secure, performant database queries using parameterized queries, eager loading, proper indexing, and transactions. Use this skill when writing database query code, ORM query methods, SQL statements, or data fetching logic. Use this when preventing SQL injection with parameterized queries, optimizing queries to avoid N+1 problems with eager loading, selecting specific columns instead of SELECT *, implementing database transactions for related operations, adding query timeouts, or caching expensive queries. Use this when working on repository files, service files with database access, query builder code, or any file that retrieves or manipulates data from databases.
migration-helper
trust-chain-organization/sagebaseAssists in creating database migrations for Polibase. Activates when creating migration files, modifying database schema, or adding tables/columns/indexes. Ensures sequential numbering, proper naming, and mandatory addition to 02_run_migrations.sql to prevent inconsistent database states.
backend-migrations
webdriverio/desktop-mobile-testingYour approach to handling backend migrations. Use this skill when working on files where backend migrations comes into play.
agentdb-advanced-features
ruvnet/claude-flow"Master advanced AgentDB features including QUIC synchronization, multi-database management, custom distance metrics, hybrid search, and distributed systems integration. Use when building distributed AI systems, multi-agent coordination, or advanced vector search applications."
agentdb-performance-optimization
ruvnet/claude-flow"Optimize AgentDB performance with quantization (4-32x memory reduction), HNSW indexing (150x faster search), caching, and batch operations. Use when optimizing memory usage, improving search speed, or scaling to millions of vectors."
qdrant-vector-database-integration
giuseppe-trisciuoglio/developer-kitQdrant vector database integration patterns with LangChain4j. Store embeddings, similarity search, and vector management for Java applications. Use when implementing vector-based retrieval for RAG systems, semantic search, or recommendation engines.
surrealdb-python
ActiveInferenceInstitute/Journal-UtilitiesMaster 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.
vector-database-management
manutej/luxor-claude-marketplaceComprehensive guide for managing vector databases including Pinecone, Weaviate, and Chroma for semantic search, RAG systems, and similarity-based applications
mongodb
samhvw8/dotfilesGuide for implementing MongoDB - a document database platform with CRUD operations, aggregation pipelines, indexing, replication, sharding, search capabilities, and comprehensive security. Use when working with MongoDB databases, designing schemas, writing queries, optimizing performance, configuring deployments (Atlas/self-managed/Kubernetes), implementing security, or integrating with applications through 15+ official drivers. (project)
agentdb-advanced-features
Dmccarty30/Journeyman-Jobs"Master advanced AgentDB features including QUIC synchronization, multi-database management, custom distance metrics, hybrid search, and distributed systems integration. Use when building distributed AI systems, multi-agent coordination, or advanced vector search applications."
redis-integration
omerakben/omer-akbenRedis and Upstash Vector integration patterns for rate-limiting, vector search, embeddings, and memory systems. Use when implementing caching, rate-limiting, or semantic search features.
firebase-deployer
ainexllc/ClaudeCodeTrainingDeploy Firebase Firestore security rules and indexes automatically. Use when Firestore query errors mention "requires an index", when firestore.rules or firestore.indexes.json are modified, or when user requests Firebase deployment.
surrealdartb
cotw-fabier/surrealdartbUse this skill when working with the SurrealDartB package in Dart/Flutter projects. This includes creating embedded SurrealDB databases, performing CRUD operations, managing schemas with code generation, working with vector embeddings for AI/ML applications, building type-safe queries with ORM features, and handling migrations. Invoke when user mentions SurrealDB, embedded databases, vector search, semantic similarity, or asks to implement database features in Dart/Flutter.
elasticsearch
lawless-m/FreeBirdElasticsearch 5.2 operations using HTTP API - searching, indexing, bulk operations, scroll API, and alias management
drizzle-orm
oriolrius/pki-manager-webExpert guidance for Drizzle ORM including schema definition, queries, relations, migrations, TypeScript integration with SQLite/PostgreSQL, and Drizzle Studio. Use this when working with type-safe database operations, schema management, or ORM queries.
designing-dynamodb-tables
swapkats/robinSpecialized skill for designing AWS DynamoDB single-table schemas with optimized access patterns. Use when modeling data, designing table structure, or optimizing DynamoDB queries for production applications.