Best SQL and Databases Claude Skills & MCP Tools (2026)

trino-optimizer

TD Trino performance optimization including CTAS (5x faster), UDP bucketing for ID lookups, magic comments for join distribution, REGEXP_LIKE vs LIKE, and approx functions.

[SQL and Databases]

hive

from treasure-data★ 3

TD Hive SQL with TD-specific functions and Hive-only features (lateral view, explode, MAPJOIN hint). Use when Trino memory errors occur or for Hive-specific syntax.

[SQL and Databases]

Expert documentation generation for golden layers. Detects SCD types, documents business rules, metric definitions, aggregation logic, and data quality scoring. Use when documenting golden layer tables.

[SQL and Databases]

cool-mysql

from StirlingMarketingGroup★ 3

Use this skill when working with the cool-mysql library for Go. This skill provides comprehensive guidance on using cool-mysql's MySQL helper functions, including dual connection pools, named parameters, template syntax, caching strategies, and advanced query patterns. Apply when writing database code, optimizing queries, setting up caching, or migrating from database/sql.

[SQL and Databases]

database

from vapvarun★ 3

Database design, optimization, and management for SQL and NoSQL databases. Covers schema design, indexing, query optimization, migrations, and database best practices. Use when designing database schemas, optimizing queries, troubleshooting database performance, or implementing data models.

[SQL and Databases]

dynamic-schema-design

from melodic-software★ 3

Use when implementing flexible content schemas using EF Core JSON columns, `OwnsOne().ToJson()` patterns, or designing dynamic field storage that avoids migrations. Covers JSON column configuration, LINQ querying of JSON properties, indexing strategies, and schema evolution patterns for headless CMS architectures.

[SQL and Databases]

db-migration

from scotthavird★ 2

Automatically triggered for database migrations, schema changes, and data transformations. Use when working with database structure, migrations, or ORM models.

[SQL and Databases]

databases

from vibery-studio★ 2

Work 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.

[SQL and Databases]

dotnet-ef-migrations

from onesmartguy★ 2

Master Entity Framework Core migrations with code-first approach, migration strategies, data seeding, rollback procedures, and production deployment patterns. Use when managing database schema changes in .NET applications.

[SQL and Databases]

query-optimization

from cyperx84★ 2

Techniques for optimizing database queries, indexing strategies, and performance tuning for SQL databases

[SQL and Databases]

postgis

from troykelly★ 2

MANDATORY when working with geographic data, spatial queries, geometry operations, or location-based features - enforces PostGIS 3.6.1 best practices including ST_CoverageClean, SFCGAL 3D functions, and bigint topology

[SQL and Databases]

postgres-rls

from troykelly★ 2

MANDATORY when touching auth tables, tenant isolation, RLS policies, or multi-tenant database code - enforces Row Level Security best practices and catches common bypass vulnerabilities

[SQL and Databases]

database-architecture

from troykelly★ 2

MANDATORY when designing schemas, writing migrations, creating indexes, or making architectural database decisions - enforces PostgreSQL 18 best practices including AIO, UUIDv7, temporal constraints, and modern indexing strategies

[SQL and Databases]

timescaledb

from troykelly★ 2

MANDATORY when working with time-series data, hypertables, continuous aggregates, or compression - enforces TimescaleDB 2.24.0 best practices including lightning-fast recompression, UUIDv7 continuous aggregates, and Direct Compress

[SQL and Databases]

koan-multi-provider

from sylin-org★ 2

Provider transparency, capability detection, context routing (partition/source/adapter)

[SQL and Databases]

database-designer

from masanao-ohba★ 2

Designs database schemas and migrations for PHP/CakePHP applications with multi-tenant support

[SQL and Databases]

sql-expert

from QuestForTech-Investments★ 2

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

[SQL and Databases]

brokle-migration-workflow

from brokle-ai★ 2

Use 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 and Databases]

drizzle-migration

from Dexploarer★ 2

Execute the proper Drizzle Kit workflow for database schema migrations in asset-forge. Use this when the user asks to create a database migration, update the database schema, or when schema changes need to be applied to the database.

[SQL and Databases]

debugging-orm-queries

from galihcitta★ 2

Converts ORM calls to raw SQL and analyzes query performance. Detects N+1 queries, missing indexes, and other anti-patterns. Use when debugging slow queries, tracing ORM-generated SQL, or optimizing database performance for Sequelize, Prisma, TypeORM (Node.js), GORM, sqlc, sqlx, ent (Go), or SQLAlchemy, Django ORM, Peewee (Python).

[SQL and Databases]

optimizing-queries

from galihcitta★ 2

Analyzes and optimizes SQL/NoSQL queries for performance. Use when reviewing query performance, optimizing slow queries, analyzing EXPLAIN output, suggesting indexes, identifying N+1 problems, recommending query rewrites, or improving database access patterns. Supports PostgreSQL, MySQL, SQLite, MongoDB, Redis, DynamoDB, and Elasticsearch.

[SQL and Databases]

multi-tenant-postgres

from raphaelmansuy★ 2

Implement multi-tenant PostgreSQL database layer with row-level security. Use for database schema design, tenant isolation, migrations, connection pooling, and data access patterns. Triggers on "database schema", "PostgreSQL", "multi-tenant", "row-level security", "RLS", "database migration", "sqlc", or when implementing the data layer for AgentStack.

[SQL and Databases]

bel-crm-sql-rules

from bennoloeffler★ 2

CRITICAL: PostgreSQL MCP Server SQL limitations and correct patterns.This skill MUST be consulted before writing any SQL for the CRM database.Documents what works and what DOES NOT work with mcp__postgresql__ tools.

[SQL and Databases]