🗄️SQL and Databases Skills
Browse the best SQL and Databases skills for Claude Code, Codex, Cursor and other AI agents.
1,171 skills · Page 18 of 49
neo4j-cypher
★ 2Expert guidance for Neo4j Cypher queries and MCP server tools. Use when working with mcp__neo4j__ tools for query execution, schema introspection, and graph operations.
lumen-ai
★ 2Master AI-powered natural language data exploration with Lumen AI. Use this skill when building conversational data analysis interfaces, enabling natural language queries to databases, creating custom AI agents for domain-specific analytics, implementing RAG with document context, or deploying self-service analytics with LLM-generated SQL and visualizations.
sql-query-optimizer
★ 2Analyzes 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".
prisma-migration-assistant
★ 2Plans 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".
schema-consistency-checker
★ 2Audits database schemas for naming conventions, type consistency, nullability patterns, and missing constraints. Provides violations report with recommended fixes. Use for "schema validation", "database linting", "schema standards", or "consistency checks".
data-retention-archiving-planner
★ 2Plans and implements data retention policies with archival strategies, compliance requirements, automated cleanup jobs, and cold storage migration. Use for "data retention", "data archival", "GDPR compliance", or "storage optimization".
data-integrity-auditor
★ 2Detects data integrity issues including orphaned records, broken foreign key relationships, constraint violations, and provides automated fix migrations. Use for "data integrity", "orphaned records", "broken relationships", or "data quality".
migration-planner
★ 2Builds 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".
sql-optimization
★ 2Analyzes and optimizes SQL queries for better performance, including index design and query rewriting. Trigger keywords: sql, query optimization, slow query, index, explain, performance, database tuning.
database-design
★ 2Designs database schemas, relationships, indexes, and migrations for relational and NoSQL databases. Trigger keywords: database design, schema, migration, ERD, normalization, index, foreign key, table design.
database-migration
★ 2Database schema change and Alembic migration expertise. Use when modifying database models, creating migrations, handling rollbacks, or troubleshooting migration issues. Ensures data integrity and safe schema evolution.
postgres
★ 1Execute read-only SQL queries against multiple PostgreSQL databases. Use when: (1) querying PostgreSQL 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.
sql-query
★ 1Generate and optimize SQL queries for data retrieval and analysis
fsharp-persistence
★ 1Implement data persistence using SQLite with Dapper, JSON files, or event sourcing.Use when: "database", "save data", "store", "CRUD", "create table", "query", "SQL","SQLite", "Dapper", "file storage", "JSON file", "event sourcing", "persistence","read from database", "write to database", "data access", "repository".Creates code in src/Server/Persistence.fs with async I/O patterns.
neon-postgres
★ 1Neon PostgreSQL serverless database - connection pooling, branching, serverless driver, and optimization. Use when deploying to Neon or building serverless applications.
drizzle-orm
★ 1Drizzle ORM for TypeScript - type-safe SQL queries, schema definitions, migrations, and relations. Use when building database layers in Next.js or Node.js applications.
database-assistant
★ 1Activates when user needs help with database design, SQL queries, migrations, or ORM usage. Triggers on "database schema", "SQL query", "migration", "optimize query", "foreign key", "index", "normalize", "ORM", "Prisma", "TypeORM", "SQLAlchemy", or database-related questions.
understanding-data
★ 1Component skill for systematic data profiling and exploration in DataPeeker analysis sessions
using-sqlite
★ 1Use when working with SQLite databases in DataPeeker analysis sessions - querying data, importing CSVs, exploring schemas, formatting output, or optimizing performance. Provides task-oriented guidance for effective SQLite CLI usage in data analysis workflows.
writing-queries
★ 1Component skill for systematic SQL query development in DataPeeker analysis sessions
importing-data
★ 1Systematic CSV import process - discover structure, design schema, standardize formats, import to database, detect quality issues (component skill for DataPeeker analysis sessions)
detect-foreign-keys
★ 1Identify foreign key relationships between tables using heuristics, value overlap analysis, and referential integrity checks
supabase-engineer
★ 1Database specialist - handles RLS policies, migrations, type generation, and Supabase integration patterns.
data-modeling
★ 1Design Glide data models - tables, columns, column types, and calculation architecture.Use when creating tables, designing data structures, choosing column types, or planning relationships.