--- title: Top Databases & Schemas Skills slug: databases-schemas type: primary-category canonical: https://top-agent-skills.com/top-skills-for-databases-schemas skills: 14 rubric: 1.0 updated: 2026-08-19 --- # Top Databases & Schemas Skills **dbhub** is the top-ranked databases Skill at 56/100: One skill across Postgres, MySQL, SQL Server, MariaDB and SQLite — and its actual job is forcing explore-before-query on real schemas. PlanetScale workflows, schema design conventions, query patterns, migrations. 14 Skills indexed, ranked by a published composite score (https://top-agent-skills.com/about/methodology). Content last changed 2026-08-19. ## The ranking ### 1. dbhub — score 56/100 (verified-org) One skill across Postgres, MySQL, SQL Server, MariaDB and SQLite — and its actual job is forcing explore-before-query on real schemas. - Best for: Querying an unfamiliar production-shaped schema, where the agent guessing table and column names is the failure you are trying to prevent. - Not ideal for: Setups without MCP. It requires the DBHub MCP server plus a DSN, and it can execute SQL — so scope the connection to a read-only role unless writes are the point. - Publisher: Bytebase · MIT - Verified on: claude-code ```bash npx @bytebase/dbhub@latest --transport http --port 8080 --dsn "postgres://user:password@localhost:5432/dbname" ``` Full entry: https://top-agent-skills.com/skill/dbhub (https://top-agent-skills.com/skill/dbhub.md) ### 2. postgres — score 55/100 (verified-org) The generalist Postgres skill the ecosystem was missing — schema, indexing, extensions and migrations, from a Postgres company. - Best for: Any Postgres decision where the default answer is wrong: choosing between B-tree and GIN, partitioning a large table, or picking an index type for pgvector at your data size. - Not ideal for: MySQL or SQL Server work. It is Postgres-specific by design, including the extension ecosystem (pgvector, PostGIS, TimescaleDB) that makes Postgres advice non-transferable. - Publisher: TigerData (Timescale) · Apache-2.0 - Verified on: claude-code ```bash npx skills add timescale/pg-aiguide --skill postgres ``` Full entry: https://top-agent-skills.com/skill/postgres-aiguide (https://top-agent-skills.com/skill/postgres-aiguide.md) ### 3. postgres-database-migration — score 55/100 (verified-org) Zero-downtime Postgres migrations, with the locking behaviour spelled out — which ALTER TABLE takes an AccessExclusiveLock and what to do instead. - Best for: A schema change on a live table where the failure mode is a lock that takes production down, not a syntax error. - Not ideal for: Greenfield schemas with no data and no traffic — the whole value here is in the constraints that only exist once a table is live. - Publisher: TigerData (Timescale) · Apache-2.0 - Verified on: claude-code ```bash npx skills add timescale/pg-aiguide --skill postgres-database-migration ``` Full entry: https://top-agent-skills.com/skill/postgres-migrations (https://top-agent-skills.com/skill/postgres-migrations.md) ### 4. design-postgres-tables — score 55/100 (verified-org) Schema design decisions made explicitly: data types, key strategy, JSONB versus columns, and when partitioning earns its complexity. - Best for: Designing a new schema, or reviewing one before it accumulates the data that makes changing it expensive. - Not ideal for: Applying a migration to an existing live table — reach for the migration skill instead, which covers the locking behaviour this one does not. - Publisher: TigerData (Timescale) · Apache-2.0 - Verified on: claude-code ```bash npx skills add timescale/pg-aiguide --skill design-postgres-tables ``` Full entry: https://top-agent-skills.com/skill/postgres-table-design (https://top-agent-skills.com/skill/postgres-table-design.md) ### 5. qdrant-advisor — score 55/100 (verified-org) A self-updating vector-database skill: it fetches current Qdrant guidance at run time instead of shipping a snapshot that rots. - Best for: Diagnosing a Qdrant deployment that is slow, memory-hungry, or returning poor results — the failure modes where stale advice is worse than none. - Not ideal for: Air-gapped environments. It needs network access to skills.qdrant.tech to load current guidance, which is exactly the design that keeps it fresh. - Publisher: Qdrant · Apache-2.0 - Verified on: claude-code ```bash npx skills add qdrant/skills/meta/qdrant-advisor ``` Full entry: https://top-agent-skills.com/skill/qdrant-advisor (https://top-agent-skills.com/skill/qdrant-advisor.md) ### 6. turso-db — score 53/100 (verified-org) The SQLite slot, filled by Turso — and unusually, a skill that actively steers the agent off the stale API surface web search returns. Full entry: https://top-agent-skills.com/skill/turso-db (https://top-agent-skills.com/skill/turso-db.md) ### 7. weaviate — score 52/100 (verified-org) The vector-database skill that ships executable scripts rather than prose — the agent runs the query instead of describing it. Full entry: https://top-agent-skills.com/skill/weaviate-skill (https://top-agent-skills.com/skill/weaviate-skill.md) ### 8. supabase-skill — score 51/100 (verified-org) Supabase done right. RLS policies, edge functions, realtime, auth — in idiomatic patterns. Full entry: https://top-agent-skills.com/skill/supabase-skill (https://top-agent-skills.com/skill/supabase-skill.md) ### 9. neon-postgres — score 51/100 (verified-org) Neon serverless Postgres done right — branching, pooling, and scale-to-zero, from Neon. Full entry: https://top-agent-skills.com/skill/neon-postgres (https://top-agent-skills.com/skill/neon-postgres.md) ### 10. planetscale-skills — score 49/100 (verified-org) PlanetScale's schema branching and index-aware queries, packaged for agents. Full entry: https://top-agent-skills.com/skill/planetscale-skills (https://top-agent-skills.com/skill/planetscale-skills.md) ### 11. prisma-orm — score 49/100 (verified-org) Prisma migrations and queries by the book. Index-aware, migration-safe, type-correct. Full entry: https://top-agent-skills.com/skill/prisma-orm (https://top-agent-skills.com/skill/prisma-orm.md) ### 12. redis-cache-patterns — score 49/100 (verified-org) Caching without the bugs. Invalidation, write-through, cache-aside, distributed locks. Full entry: https://top-agent-skills.com/skill/redis-cache-patterns (https://top-agent-skills.com/skill/redis-cache-patterns.md) ### 13. mongodb-patterns — score 47/100 (verified-org) MongoDB aggregations and indexing without the foot-guns. Full entry: https://top-agent-skills.com/skill/mongodb-patterns (https://top-agent-skills.com/skill/mongodb-patterns.md) ### 14. duckdb-skills — score 46/100 (verified-org) In-process analytical SQL over CSV, Parquet, and Excel — no warehouse, no server. Full entry: https://top-agent-skills.com/skill/duckdb-skills (https://top-agent-skills.com/skill/duckdb-skills.md) ## About this category The best agent skills for databases and schemas in 2026 handle safe migrations as well as design — flagging the NOT NULL footgun on large tables, estimating online index build impact on write-heavy loads, and covering Drizzle and Prisma ORM patterns alongside raw Postgres, MySQL, and SQLite DDL. Database & schema Skills give agents the structured workflow needed to design tables, write migrations, optimize queries, and avoid the classic footguns — N+1 queries, missing indexes, lock contention, schema drift between environments. The category covers Postgres, MySQL, PlanetScale, Supabase, SQLite, Mongo, and the increasingly common Drizzle / Prisma ORM patterns. Common workflows include designing a schema for a new feature, writing a safe migration (NOT NULL adds, large backfills, online index builds), optimizing a slow query with EXPLAIN ANALYZE, generating an ER diagram from an existing schema, designing partitioning strategies for large tables, and reviewing migrations for safety before merge. Several Skills pair with Supabase, PlanetScale, Neon or Snowflake MCP servers for live schema inspection. Backend engineers, data platform engineers, and product engineers shipping schema changes use these. Composite scoring weights provenance, install count, and how well the Skill handles migrations specifically — the highest-risk part of any database workflow. Skills that flag dangerous migration patterns (NOT NULL without default on large tables, online index build estimates) rank above those that just generate SQL. ## Common questions **Postgres, MySQL or SQLite?** The schema-design patterns largely overlap. Migration safety and operational concerns diverge sharply — Postgres has online DDL for most operations, MySQL's online DDL is narrower, SQLite mostly rewrites the table. The top Skills warn about platform-specific footguns. **Can these Skills run migrations?** They generate and review; whether the agent runs them depends on the agent and your approval. Claude Code with a Postgres MCP server can; Claude.ai web only generates. **How do they handle ORM-specific patterns?** Drizzle and Prisma have dedicated Skills that produce idiomatic schema definitions and migrations. Generic SQL Skills fall back to raw DDL. **Are these Skills useful for query optimization?** Yes — they read EXPLAIN ANALYZE output and propose index, query-shape, or schema changes. The cloud-native data warehouse Skills (BigQuery, Snowflake) are particularly useful here. **Do they catch unsafe migrations?** The top Skills flag the well-known footguns — NOT NULL on a large table without a default, multi-step migrations that need separate deploys, online index build assumptions on a write-heavy table. --- _Top Agent Skills. Machine-readable twin of https://top-agent-skills.com/top-skills-for-databases-schemas._ _JSON: https://top-agent-skills.com/top-skills-for-databases-schemas.json · whole catalog: https://top-agent-skills.com/skills.json (CC BY 4.0)_