Topic · Databases
Best database schema design skills for Claude Code, Codex and other agents.
- skills
- 390
- official
- 20
Database schema design skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Gives the agent Postgres rules to consult before writing or changing tables, queries, indexes, RLS policies or migrations, and when diagnosing slow queries. | supabase/ | 2.7k | 24 repos | ~808 | Automated safety check: Pass | MIT | 5 days ago |
| 2 | Reviews backend code under api/ for concrete, reproducible defects, routes to rule packs for architecture, schema, repositories and SQLAlchemy, and ranks findings from P0 to P3. | langgenius/ | 158k | — | ~676 | Automated safety check: Pass | Unknown | today |
| 3 | Guides safe, measurable MySQL and InnoDB changes across schema design, indexing, query tuning, transactions, locking and replication, with rollout steps. | planetscale/ | 698 | 3 repos | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 4 | Explore and understand codebases using SocratiCode semantic search, dependency graphs, and context artifacts. | giancarloerra/ | 3.3k | 1 repo | ~1.5k | Automated safety check: Pass | AGPL-3.0 | 5 days ago |
| 5 | Walks through adding a new persisted memory kind to EverOS: choose storage among Markdown, SQLite and LanceDB, pick a Markdown strategy, then wire schemas, repos and writers. | EverMind-AI/ | 13k | — | ~2.6k | Automated safety check: Pass | Apache-2.0 | today |
| 6 | Rules for writing Django migrations in Saleor that avoid long table locks and stay compatible with zero-downtime rolling deploys. | saleor/ | 23k | — | ~1.6k | Automated safety check: Pass | BSD-3-Clause | yesterday |
| 7 | A skill your agent uses when optimizing Jazz applications for speed, responsiveness, and scalability. | garden-co/ | 2.5k | — | ~1.9k | Automated safety check: Pass | MIT | 1 mo ago |
| 8 | Currency handling patterns for the Dinero.js money library. An agent skill from dinerojs/dinero.js. | dinerojs/ | 6.8k | — | ~650 | Automated safety check: Pass | MIT | yesterday |
| 9 | Explore an existing PostgreSQL database before answering questions about its data or writing SQL. | timescale/ | 1.9k | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | 6 days ago |
| 10 | Guides SQLite schema changes in the Cursor BYOK server, keeping SQLx migrations, the Rust store, API contracts and fixtures aligned. | leookun/ | 3.2k | — | ~1.3k | Automated safety check: Pass | MIT | 9 days ago |
| 11 | 11.Suiko 日本語文書のAI由来の均一さ、翻訳調、不自然さ、論旨、読解負荷を、決定的なRust CLIと目視で診断し、依頼に応じて書く・直す。日本語の学術論文・研究報告では、中心命題、用語、論証、DOCX/PDF納品を監査契約で確認する。Use when the user explicitly mentions suiko, asks whether Japanese text looks… | nwiizo/ | 114 | — | ~1.8k | Automated safety check: Pass | MIT | today |
| 12 | Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. | ynulihao/ | 617 | 10 repos | ~3.3k | Automated safety check: Pass | No licence | 7 mo ago |
| 13 | Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. | MoizIbnYousaf/ | 1.1k | 1 repo | ~1.2k | Automated safety check: Pass | MIT | 16 days ago |
| 14 | 14.Add Mpk Task Step-by-step guide for adding a new task implementation to Mirage Persistent Kernel (MPK). | mirage-project/ | 2.5k | — | ~4.5k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 15 | Plans the stack, database schema and API for an app clone, from the recon map replica-recon wrote. | Jakeschincariol/ | 734 | — | ~1.1k | Automated safety check: Pass | MIT | 4 days ago |
| 16 | 16.Effect TS Write idiomatic Effect v4 TypeScript following official best practices from effect-solutions and the Effect source. | mattiacerutti/ | 187 | — | ~2.8k | Automated safety check: Pass | MIT | today |
| 17 | 17.Drizzle Erd A skill your agent uses when needing to visualize database schema, generate ERD diagrams from Drizzle ORM schemas, or understand table relationships | hiroppy/ | 418 | — | ~627 | Automated safety check: Pass | MIT | today |
| 18 | 18.Tsp Csharp Comprehensive C and .NET development skill for TSP projects. | querylenshq/ | 225 | — | ~1.3k | Automated safety check: Pass | MIT | 1 mo ago |
| 19 | Define implementation contracts (APIs and data models) that developers will build against during PRD v0.6 Architecture. | mattgierhart/ | 179 | 1 repo | ~3.4k | Automated safety check: Pass | MIT | 1 mo ago |
| 20 | Diagnose and correct GPT-QModel tokenizer initialization, tokenization normalization, special-token handling, prompt rendering, and chat-template problems. | ModelCloud/ | 1.3k | — | ~1.1k | Automated safety check: Pass | Unknown | today |
| 21 | Deep dive into SwiftData design patterns and best practices. | KartikLabhshetwar/ | 2.4k | 2 repos | ~1.2k | Automated safety check: Pass | Unknown | 6 days ago |
| 22 | Overview and information about Neki, the sharded Postgres product by PlanetScale. Load when working with Neki-related tasks and the need to scale or… | planetscale/ | 698 | 1 repo | ~483 | Automated safety check: Pass | MIT | yesterday |
| 23 | Validates SQL schema files for compliance with internal safety and naming policies. | rominirani/ | 591 | — | ~264 | Automated safety check: Pass | No licence | 3 mo ago |
| 24 | Friendly, step-by-step setup for ERD Studio in an existing dbt project, for people who may be new to dbt or data modelling. | liam-machine/ | 165 | — | ~8.5k | Automated safety check: Pass | Unknown | 3 days ago |
| 25 | A skill your agent uses when the user wants to design or extend a FlashAttention-style forward kernel on B200/Blackwell, involving the two MMAs QKᵀ and PV, online softmax, S/P/O in TMEM, warp roles… | mirage-project/ | 2.5k | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 26 | 26.Effect TS Write idiomatic Effect v4 TypeScript verified against the pinned effect@4.0.0-rc.112 source. | tellahq/ | 392 | — | ~3.7k | Automated safety check: Pass | MIT | today |
| 27 | 27.Shadmin Dev Apply Shadmin feature-development standards (backend Go/Gin/Ent + frontend React/TS). | ahaodev/ | 174 | — | ~2.7k | Automated safety check: Pass | MIT | 5 days ago |
| 28 | 28.Walkthrough Generates a self-contained HTML file with an interactive, clickable Mermaid diagram (flowchart or ER diagram) that explains how a codebase feature, flow, architecture, or database schema works. | alexanderop/ | 141 | — | ~3.4k | Automated safety check: Notes | No licence | 6 mo ago |
| 29 | Turns a Tushare API doc URL into a full data plugin for the stock_datasource repo: extractor, ClickHouse schema, query service, config and curl examples. | Yourdaylight/ | 188 | — | ~2.5k | Automated safety check: Pass | MIT | 29 days ago |
| 30 | Sanity development best practices for schema design, GROQ queries, TypeGen, Visual Editing, images, Portable Text, Studio structure, localization, migrations, Sanity Functions, Blueprints, and… | robotostudio/ | 182 | — | ~940 | Automated safety check: Pass | MIT | 2 days ago |
| 31 | Guidance on Vitess sharding, VSchema design, query tuning and connection problems for MySQL-compatible databases running on PlanetScale. | planetscale/ | 698 | 1 repo | ~1.2k | Automated safety check: Pass | MIT | yesterday |
| 32 | Audit experiment integrity before claiming results. An agent skill from wanshuiyin/Auto-claude-code-research-in-sleep. | wanshuiyin/ | 17k | 1 repo | ~2.7k | Automated safety check: Notes | MIT | today |
| 33 | SPD V1 Batch. An agent skill from flaqai/backlink_skills. | flaqai/ | 750 | — | ~1.7k | Automated safety check: Pass | MIT | 13 days ago |
| 34 | Design robust, scalable database schemas for SQL and NoSQL databases. | meshery/ | 151 | 3 repos | ~4.4k | Automated safety check: Pass | MIT | 16 days ago |
| 35 | 35.Datamodellm Create visual data models for database schemas using Nimbalyst's DataModelLM editor. | nimbalyst/ | 1.8k | — | ~713 | Automated safety check: Pass | MIT | 2 days ago |
| 36 | Designs and debugs Elixir persistence with Ecto: schemas, changesets, queries, preloads, migrations and multi-tenancy, kept within application contexts. | georgeguimaraes/ | 184 | — | ~1.2k | Automated safety check: Pass | Apache-2.0 | 17 days ago |
| 37 | Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode. | DanielPodolsky/ | 290 | 1 repo | ~1.6k | Automated safety check: Pass | MIT | 3 mo ago |
| 38 | 38.Modeler Build, validate, and manage semantic models using Sidemantic. | sidequery/ | 129 | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | today |
| 39 | A skill your agent uses for general PostgreSQL table design. | timescale/ | 1.9k | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | 6 days ago |
| 40 | Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context… | unxed/ | 240 | 2 repos | ~2.9k | Automated safety check: Pass | MIT | today |
| 41 | Database performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration. | cin12211/ | 223 | — | ~2.8k | Automated safety check: Pass | MIT | 16 days ago |
| 42 | Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities. | databricks/ | 345 | 1 repo | ~2.8k | Automated safety check: Pass | Unknown | yesterday |
| 43 | Design or review schemas for crates/cloudsync using SQLite Sync constraints, not generic SQLite advice. | fastrepl/ | 9.4k | — | ~1.9k | Automated safety check: Pass | MIT | today |
| 44 | Safely run database schema migrations. An agent skill from agulli/atlas-agents. | agulli/ | 578 | — | ~702 | Automated safety check: Pass | MIT | 2 mo ago |
| 45 | Design and implement collaborative data schemas using the Jazz framework. | garden-co/ | 2.5k | — | ~3.2k | Automated safety check: Pass | MIT | 1 mo ago |
| 46 | A skill your agent uses when generating or regenerating Drizzle migration files, changing database schema tables or columns, resolving migration sequence conflicts after rebase, reviewing migration… | kurealnum/ | 290 | — | ~820 | Automated safety check: Pass | No licence | 5 mo ago |
| 47 | MongoDB schema design patterns and anti-patterns. An agent skill from mongodb/agent-skills. | mongodb/ | 190 | 2 repos | ~3.4k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 48 | 48.Zhtw Verify How a zhtw-mcp change is validated - make check as the gate, the generated tables and the ruleset normalization that have to be current before it passes, the formatter chain in scripts/indent.sh… | sysprog21/ | 488 | — | ~2.8k | Automated safety check: Pass | MIT | 2 days ago |
Questions, answered from the data.
What is the best database schema design skill?
Supabase Postgres Best Practices (official) from supabase/agent-skills ranks first of the 390 database schema design skills listed here, with the highest score: its repository has 2.7k GitHub stars, 24 other GitHub owners carry a copy, its SKILL.md loads about 808 tokens and it passes the automated safety check with no findings. Next come Backend Code Review and MySQL Schema and Query Tuning.
Which database schema design skills are official?
20 of the 390 database schema design skills are official, published by the vendor's own GitHub organization: Supabase Postgres Best Practices, MySQL Schema and Query Tuning, PlanetScale Neki Overview, Vitess for PlanetScale, Databricks Dbsql and 15 more.
How are these skills ranked?
By Skill Navigator score, which combines the GitHub stars of the skill's repository (shared across that repo's skills and discounted for large collections), how many other GitHub owners carry a copy of the skill, and automated SKILL.md quality checks, minus penalties for safety-check warnings and for each further skill from the same repository. Skills that fail the safety check are not listed.