250 free skills · page 3 of 5
Database skills
Skills for databases — schema design, migrations, indexing, query optimization, and working with Postgres, MySQL, MongoDB, Redis.
Real files from public repositories — hand-curated, never invented. Sorted by installs.
3 / 5page
database-migration-managementaj-geddes/useful-ai-promptsImplement robust database migration systems with version control, rollback capabilities, and data transformation strategies. Includes migration frameworks and production deployment patterns.Database475database-indexing-strategyaj-geddes/useful-ai-promptsDesign comprehensive indexing strategies to improve query performance, reduce lock contention, and maintain data integrity. Covers index types, design patterns, and maintenance procedures.Database462
design-postgres-tablestimescale/pg-aiguideEnable with ALTER TABLE tbl ENABLE ROW LEVEL SECURITY. Create policies: CREATE POLICY user_access ON orders FOR SELECT TO app_users USING (user_id = current_user_id()). Built-in user-based access control at the row level.Database456
sql-prosickn33/agentic-awesome-skillsMaster modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.Database448
fixed-income-structuredjoellewis/finance_skillsAnalyze structured fixed income products including mortgage-backed securities, asset-backed securities, and CLOs. Use when the user asks about MBS, ABS, CLOs, CDOs, prepayment risk, tranching, or waterfall structures. Also trigger when users mention 'mortgage bonds', 'agency MBS', 'pass-through securities', 'PSA prepayment speed', 'negative convexity', 'extension risk', 'contraction risk', 'CMO tranches', 'securitization', or ask how structured products redistribute credit and prepayment risk.Database444
infisical-dynamic-secretsinfisical/ai-skillsGuide for configuring Infisical Dynamic Secrets — on-demand, short-lived credentials for databases, cloud IAM, SSH, and Kubernetes. Covers 27 providers including PostgreSQL, MySQL, Redis, MongoDB, AWS IAM, GCP IAM, SSH certificates, Kubernetes service accounts, and more. Use this skill when someone asks about: dynamic secrets, ephemeral database credentials, short-lived tokens, rotating database users, dynamic PostgreSQL/MySQL/Redis credentials, SSH certificates, temporary AWS IAM users, or 'how do I generate temporary credentials with Infisical'.Database441
upstash-redis-kvintellectronica/agent-skillsRead and write to Upstash Redis-compatible key-value store via REST API. Use when there is a need to save or retrieve key-value data, use Redis features (caching, counters, lists, sets, hashes, sorted sets, etc.) for the current interaction, or when the user explicitly asks to use Upstash or Redis.Database440
database-schema-designsecondsky/claude-skillsDatabase schema design for PostgreSQL/MySQL with normalization, relationships, constraints. Use for new databases, schema reviews, migrations, or encountering missing PKs/FKs, wrong data types, premature denormalization, EAV anti-pattern.Database439transaction-managementaj-geddes/useful-ai-promptsImplement robust transaction management with ACID compliance, concurrency control, and error handling. Covers isolation levels, locking strategies, and deadlock resolution.Database434
database-securityzhaoxuya520/reverse-skillUse for authorized database security assessment covering PostgreSQL/MySQL/MSSQL/Mongo/Redis exposure, authz, UDF/command paths, and misconfiguration review.Database433
sqlalchemy-postgrescfircoo/claude-code-toolkitExpert guidance for SQLAlchemy 2.0 + Pydantic + PostgreSQL. Use when setting up database layers, defining models, creating migrations, or any database-related work. Automatically activated for DB tasks.Database425postgres-best-practicessickn33/agentic-awesome-skillsPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.Database415
postgresql-expertpersonamanagmentlayer/pclExpert-level PostgreSQL database administration, advanced queries, performance tuning, and production operationsDatabase408data-migration-scriptsaj-geddes/useful-ai-promptsCreate robust, safe, and reversible data migration scripts for database schema changes and data transformations with minimal downtime.Database407
redis-state-managementmanutej/luxor-claude-marketplaceComprehensive guide for Redis state management including caching strategies, session management, pub/sub patterns, distributed locks, and data structuresDatabase405
supabase-audit-rpcyoanbernabeu/supabase-pentest-skillsList and test exposed PostgreSQL RPC functions for security issues and potential RLS bypass.Database391SQLAlchemy ORM Expertmanutej/luxor-claude-marketplaceComprehensive SQLAlchemy skill for customer support tech enablement, covering ORM patterns, session management, query optimization, async operations, and PostgreSQL integrationDatabase388database-management-patternsmanutej/luxor-claude-marketplaceComprehensive guide for database management patterns covering PostgreSQL and MongoDB including schema design, indexing, transactions, replication, and performance tuningDatabase384
neon-vercel-postgresjezweb/claude-skillsStatus: Production Ready Last Updated: 2026-01-21 Dependencies: None Latest Versions: @neondatabase/serverless@1.0.2, @vercel/postgres@0.10.0, drizzle-orm@0.45.1, drizzle-kit@0.31.8, neonctl@2.19.0Database373
encore-databaseencoredev/skillsWork with PostgreSQL in Encore.ts using SQLDatabase from encore.dev/storage/sqldb — schema migrations and SQL queries.Database369
postgresql-expert-best-practices-code-reviewwispbit-ai/skillsPostgreSQL database design, migration, and performance optimization best practices. This skill should be used when writing, reviewing, or refactoring database schemas, migrations, or query patterns. Triggers on tasks involving PostgreSQL databases, schema design, migration optimization, or data modeling.Database369PostgreSQL Database Administrationmanutej/luxor-claude-marketplaceComprehensive PostgreSQL database administration skill for customer support tech enablement, covering database design, optimization, performance tuning, backup/recovery, and advanced query techniquesDatabase368supabase-extract-db-stringyoanbernabeu/supabase-pentest-skillsCRITICAL - Detect exposed PostgreSQL database connection strings in client-side code. Direct DB access is a P0 issue.Database365
mysqlsanjay3290/ai-skillsExecute read-only SQL queries against multiple MySQL databases. Use when: (1) querying MySQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.Database360nuxt-serversecondsky/claude-skills| Nuxt 4 server-side development with Nitro: API routes, server middleware, database integration, and backend patterns. Use when: creating server API routes, implementing server middleware, integrating databases (D1, PostgreSQL, Drizzle), handling file uploads, implementing WebSockets, or building backend logic with Nitro.Database342session-managementsecondsky/claude-skillsImplements secure session management with JWT tokens, Redis storage, refresh flows, and proper cookie configuration. Use when building authentication systems, managing user sessions, or implementing secure logout functionality.Database338bun-redissecondsky/claude-skillsUse when working with Redis in Bun (ioredis, Upstash), caching, pub/sub, session storage, or key-value operations.Database332
database-schema-designeronewave-ai/claude-skillsDesign optimized database schemas for SQL and NoSQL databases including tables, relationships, indexes, and constraints. Creates ERD diagrams, migration scripts, and data modeling best practices. Use when users need database design, schema optimization, or data architecture planning.Database323
sqlite-expertrightnow-ai/openfangSQLite expert for WAL mode, query optimization, embedded patterns, and advanced featuresDatabase322
railway-databasedavila7/claude-code-templatesAdd official Railway database services (Postgres, Redis, MySQL, MongoDB). Use when user wants to add a database, says "add postgres", "add redis", "add database", "connect to database", or "wire up the database". For other templates (Ghost, Strapi, n8n), use the railway-templates skill.Database316
motherduck-duckdb-sqlmotherduckdb/agent-skillsDuckDB SQL reference for MotherDuck. Use when you need exact DuckDB syntax or function behavior, friendly SQL features like QUALIFY, GROUP BY ALL, or list/struct types, MotherDuck-specific SQL such as shares, secrets, snapshots, or UNDROP, or to fix SQL errors and PostgreSQL-style SQL that fails on MotherDuck.Database311motherduck-connectmotherduckdb/agent-skillsConnect to MotherDuck from any application. Use when setting up database connectivity via the Postgres endpoint (recommended), pg_duckdb, native DuckDB API, or JDBC. Covers connection strings, authentication, SSL, and environment variable configuration.Database301motherduck-load-datamotherduckdb/agent-skillsLoad and ingest data into MotherDuck from local files, object storage (S3, GCS, Azure, R2), HTTPS, dataframes, or external databases. Use for any import or bulk-load task — CSV, Parquet, JSON, Delta, Iceberg, local DuckDB database upload — and for choosing between CTAS, INSERT...SELECT, COPY, cloud-storage secrets, and Postgres-endpoint versus native DuckDB-client paths.Database297motherduck-model-datamotherduckdb/agent-skillsDesign and build database schemas and data models in MotherDuck. Produces a file-based SQL project scaffold with a model manifest. Use for any schema design or data modeling task — creating tables, choosing data types, star schemas, wide denormalized tables, raw/staging/analytics layers, dbt-style transformation projects, or restructuring data for analytics workloads.Database294motherduck-migrate-to-motherduckmotherduckdb/agent-skillsPlan a migration onto MotherDuck. Use when moving from Snowflake, BigQuery, Redshift, PostgreSQL, dbt-heavy stacks, or lakehouse tooling and the key decisions are target pattern, cutover slices, source-vs-target validation, rollback, and native-versus-DuckLake posture.Database293migrate-postgres-tables-to-hypertablestimescale/pg-aiguideMigrate identified PostgreSQL tables to TimescaleDB hypertables with optimal configuration, migration planning and validation.Database291railway-templatesdavila7/claude-code-templatesSearch and deploy services from Railway's template marketplace. Use when user wants to add a service from a template, find templates for a specific use case, or deploy tools like Ghost, Strapi, n8n, Minio, Uptime Kuma, etc. For databases (Postgres, Redis, MySQL, MongoDB), prefer the railway-database skill.Database287postgres-hybrid-text-searchtimescale/pg-aiguideHybrid search combines keyword search (BM25) with semantic search (vector embeddings) to get the best of both: exact keyword matching and meaning-based retrieval. Use Reciprocal Rank Fusion (RRF) to merge results from both methods into a single ranked list.Database279django-cloud-sql-postgresjezweb/claude-skillsStatus: Production Ready Last Updated: 2026-01-24 Dependencies: None Latest Versions: Django@5.1, psycopg2-binary@2.9.9, gunicorn@23.0.0, google-cloud-sql-connector@1.12.0Database278database-shardingsecondsky/claude-skillsDatabase sharding for PostgreSQL/MySQL with hash/range/directory strategies. Use for horizontal scaling, multi-tenant isolation, billions of records, or encountering wrong shard keys, hotspots, cross-shard transactions, rebalancing issues.Database278
mongodbbobmatnyc/claude-mpm-skillsMongoDB - NoSQL document database with flexible schema design, aggregation pipelines, indexing strategies, and Spring Data integrationDatabase273databasesickn33/agentic-awesome-skillsDatabase development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering.Database268digitalocean-managed-databasesbobmatnyc/claude-mpm-skillsDigitalOcean Managed Databases for PostgreSQL, MySQL, Redis, MongoDB, Kafka, OpenSearch, and Valkey. Use when provisioning, scaling, or operating managed database clusters on DigitalOcean.Database263
prisma-migration-assistantpatricio0312rev/skillsPlans and executes safe Prisma schema migrations with data backfills, rollback strategies, and SQL preview. Handles complex schema changes including data transformations. Use for "Prisma migrations", "schema changes", "database migrations", or "data backfills".Database263redis-expertpersonamanagmentlayer/pclExpert-level Redis for caching, pub/sub, data structures, and high-performance applicationsDatabase261
graph-database-expertmartinholovsky/claude-skills-generatorExpert in graph database design and development with deep knowledge of graph modeling, traversals, query optimization, and relationship patterns. Specializes in SurrealDB but applies generic graph database concepts. Use when designing graph schemas, optimizing graph queries, implementing complex relationships, or building graph-based applications.Database259
GitLab Stack Config Generatorrknall/claude-skillsGenerates service-specific configuration files for GitLab stack projects in ./config directory, using .env as the primary configuration source. Creates nginx, PostgreSQL, Redis, and custom service configs with strict validation for secrets, paths, and Docker best practices. Use when setting up service configurations, creating config templates, or ensuring configs follow stack patterns.Database259
render-postgresrender-oss/skillsThis skill covers Managed Postgres on Render: how to connect, what cannot change after creation, storage behavior, limits, HA, replicas, and safe deletion. Deep dives live under references/.Database253vercel-storage-databobmatnyc/claude-mpm-skillsVercel data and storage services including Postgres, Redis, Vercel Blob, Edge Config, and data cache. Use when selecting data storage or caching on Vercel.Database253postgres-schema-designdavila7/claude-code-templatesComprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced featuresDatabase251
drizzle-safe-migrationspedronauck/skillsProduction-safe Drizzle migration workflow for schema changes that require data backfills or constraint tightening. Use when changing enums/check constraints/defaults, removing status values, or sequencing custom and generated migrations in Drizzle. Trigger on requests about Drizzle migration safety, deployment-safe backfills, migration ordering, and rollback planning. Don't use for ORMs other than Drizzle, app-layer query optimization, or greenfield schema design.Database245sql-expertpersonamanagmentlayer/pclExpert-level SQL database design, querying, optimization, and administration across PostgreSQL, MySQL, and SQL ServerDatabase244queue-job-processorpatricio0312rev/skillsImplements background job processing with BullMQ/Redis including job queues, workers, scheduling, retries, and monitoring. Use when users request "background jobs", "queue processing", "async tasks", "BullMQ", or "job scheduler".Database243sql-query-optimizerpatricio0312rev/skillsAnalyzes and optimizes SQL queries using EXPLAIN plans, index recommendations, query rewrites, and performance benchmarking. Use for "query optimization", "slow queries", "database performance", or "EXPLAIN analysis".Database242
313-frameworks-spring-db-migrations-flywayjabrena/plinthUse when you need to add or review Flyway database migrations in a Spring Boot application — Maven dependencies, db/migration scripts, spring.flyway.* configuration, baseline and validation, and alignment with JDBC or Spring Data JDBC. This should trigger for requests such as Add or review Flyway migrations in a Spring Boot project; Configure spring.flyway or db/migration layout; Add versioned Flyway SQL migrations for Spring Boot; Review Spring Boot database migration ordering; Fix repeatable Flyway migrations in a Spring project. Part of Plinth ToolkitDatabase241encore-go-databaseencoredev/skillsWork with PostgreSQL in Encore Go using sqldb.NewDatabase from encore.dev/storage/sqldb — schema migrations and SQL queries.Database235
cloudbase-agent-pythontencentcloudbase/skillsBuild production-ready AI agent backends using the CloudBase Agent Python SDK — create agents with LangGraph/CrewAI/LlamaIndex, serve them via FastAPI with AG-UI protocol streaming + OpenAI-compatible endpoints, add tools (bash, filesystem, MCP, code execution), memory (in-memory, TDAI, MySQL, MongoDB), observability (OpenTelemetry/Langfuse), and middleware (auth, logging). Use this skill when the user wants to create an AI agent server, build a chatbot backend, set up human-in-the-loop workflows, integrate MCP tools, add agent observability, or deploy an agent API — even if they don't explicitly mention 'CloudBase Agent.'Database234migration-plannerpatricio0312rev/skillsBuilds phased data and system migrations using feature flags, dual writes, backfills, and validation. Includes rollback plans and risk mitigation. Use for "data migration", "system migration", "database migration", or "platform migration".Database227drizzle-postgrespedronauck/skillsType-safe database applications with PostgreSQL 18 and Drizzle ORM.Database226413-frameworks-quarkus-db-migrations-flywayjabrena/plinthUse when you need to add or review Flyway database migrations in a Quarkus application — quarkus-flyway extension, db/migration scripts, quarkus.flyway.* configuration, migrate-at-start, and alignment with JDBC or Panache. This should trigger for requests such as Add or review Flyway migrations in a Quarkus project; Configure quarkus-flyway or db/migration layout; Add versioned Flyway SQL migrations for Quarkus; Review Quarkus database migration ordering; Configure Flyway clean migrate or baselines in Quarkus. Part of Plinth ToolkitDatabase226Other tasks
same rules, different job
