🗄️SQL and Databases Skills
Browse the best SQL and Databases skills for Claude Code, Codex, Cursor and other AI agents.
1,171 skills · Page 5 of 49
query-builder
★ 4.4kConvert natural language questions into SQL queries. Activates when users ask data questions in plain English like "show me users who signed up last week" or "find orders over $100".
06-database-script-management
★ 2.5k数据库脚本管理规范，涵盖 DDL/DML 脚本编写、版本命名规则、增量更新策略、数据迁移、回滚方案。当用户编写数据库脚本、新增表结构、修改字段、进行数据迁移或管理 SQL 版本时使用。
44-database-design
★ 2.5kBK-CI 数据库设计规范与表结构指南，涵盖命名规范、字段类型选择、索引设计、分表策略、数据归档。当用户设计数据库表、优化索引、规划分表策略或进行数据库架构设计时使用。
23-database-sharding
★ 2.5k数据库分片指南，涵盖分片策略设计、分片键选择、跨分片查询、数据迁移、分片路由规则。当用户设计数据库分片、选择分片键、处理跨分片查询或进行分片数据迁移时使用。
29-4-process-dao-database
★ 2.5kProcess 模块 DAO 层与数据库表结构详细分析，涵盖 JOOQ 使用、表结构设计、索引优化、数据分片。当用户开发 Process 数据访问、设计表结构、优化查询性能或处理数据存储时使用。
postgis-skill
★ 2.0kPostGIS-focused SQL tips, tricks and gotchas. Use when in need of dealing with geospatial data in Postgres.
neo4j-cypher-guide
★ 1.6kComprehensive guide for writing modern Neo4j Cypher read queries. Essential for text2cypher MCP tools and LLMs generating Cypher queries. Covers removed/deprecated syntax, modern replacements, CALL subqueries for reads, COLLECT patterns, sorting best practices, and Quantified Path Patterns (QPP) for efficient graph traversal.
databases
★ 1.1kWork 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.
insforge-schema-patterns
★ 1.0kDatabase schema patterns for InsForge including social graphs, e-commerce, content publishing, and multi-tenancy with RLS policies. Use when designing data models with relationships, foreign keys, or Row Level Security.
dynamodb
★ 937AWS DynamoDB NoSQL database for scalable data storage. Use when designing table schemas, writing queries, configuring indexes, managing capacity, implementing single-table design, or troubleshooting performance issues.
prisma-schema-helper
★ 878Prisma Schema Helper - Auto-activating skill for Backend Development.Triggers on: prisma schema helper, prisma schema helperPart of the Backend Development skill category.
sql-migration-generator
★ 878Sql Migration Generator - Auto-activating skill for Backend Development.Triggers on: sql migration generator, sql migration generatorPart of the Backend Development skill category.
window-function-generator
★ 878Window Function Generator - Auto-activating skill for Data Analytics.Triggers on: window function generator, window function generatorPart of the Data Analytics skill category.
spark-sql-optimizer
★ 878Spark Sql Optimizer - Auto-activating skill for Data Pipelines.Triggers on: spark sql optimizer, spark sql optimizerPart of the Data Pipelines skill category.
database-schema-designer
★ 878Database Schema Designer - Auto-activating skill for Backend Development.Triggers on: database schema designer, database schema designerPart of the Backend Development skill category.
schema-optimization-orchestrator
★ 878Multi-phase schema optimization workflow orchestrator. Creates session directories,spawns phase agents sequentially, validates outputs, aggregates results.Trigger: "run schema optimization", "optimize schema workflow", "execute schema phases"
sql-query-optimizer
★ 878Sql Query Optimizer - Auto-activating skill for Data Analytics.Triggers on: sql query optimizer, sql query optimizerPart of the Data Analytics skill category.
supabase-schema-from-requirements
★ 878Execute Supabase primary workflow: Schema from Requirements.Use when Starting a new project with defined data requirements,Refactoring an existing schema based on new features, or Creating migrations from specification documents.Trigger with phrases like "supabase schema from requirements","generate database schema with supabase".
hugging-face-datasets
★ 861Create and manage datasets on Hugging Face Hub. Supports initializing repos, defining configs/system prompts, streaming row updates, and SQL-based dataset querying/transformation. Designed to work alongside HF MCP server for comprehensive dataset workflows.
database-documentation-gen
★ 692Use when you need to work with database documentation.This skill provides automated documentation generation with comprehensive guidance and automation.Trigger with phrases like "generate docs", "document schema",or "create database documentation".
Supabase Postgres Best Practices
★ 579A powerful skill for Claude agents.
validate-with-database
★ 510Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs interactively
pg-dump-reference
★ 510Consult PostgreSQL's pg_dump implementation for guidance on system catalog queries and schema extraction when implementing pgschema features
sql-translation
★ 496Guide for adding SQL function translations to dbplyr backends. Use when implementing new database-specific R-to-SQL translations for functions like string manipulation, date/time, aggregates, or window functions.