Databases & SQL
4,697 rows from 776 repositories
Schemas, queries and the migrations between them.
What Databases & SQL skills agree on
714 skill files read, by 609 of the 712 authors on this shelf whose files we hold, 2026-09-06
The middle one of the 105 measured here is ~1.7k tokens long, counted with cl100k_base
Counted by distinct author, so one author publishing three of these counts once. Where a claim sits in fewer files than authors, that is said: a claim held by forty authors across three files is one file people copied, not forty people who agreed. Near-identical wordings are grouped and the other wordings are shown, so the grouping is yours to check.
What they tell the agent to do
- Index all foreign key columns26 of 609also worded as Index every foreign key; Index every foreign key column
- Use cursor pagination instead of offset25 of 609 in 20 filesalso worded as Use keyset pagination instead of deep OFFSET; Use keyset pagination instead of offset pagination
- Use timestamptz for timestamps21 of 609also worded as use timestamptz for all timestamp columns; use TIMESTAMPTZ for all timestamps
- Specify columns instead of using select star20 of 609 in 10 filesalso worded as use explicit columns instead of select star; specify required columns instead of using select star
- Use parameterized queries for all database interactions20 of 609 in 19 filesalso worded as Use parameterized queries for SQL; parameterize all queries
- Use Enum for categorical data17 of 609 in 7 filesalso worded as use enum types for fixed categories
- Order by frequently filtered columns17 of 609 in 7 filesalso worded as order by frequently filtered columns first; Filter on ORDER BY prefix columns
- Batch data inserts17 of 609 in 7 filesalso worded as batch data inserts instead of individual inserts; batch data for bulk inserts
- Use expand-contract pattern for schema changes17 of 609also worded as use expand-migrate-contract for all schema changes; Implement schema changes using expand and contract patterns
- Use materialized views for real-time aggregations16 of 609 in 6 files
- Partition tables by time16 of 609 in 6 filesalso worded as partition tables by time using date or month
- Use smallest appropriate data types16 of 609 in 6 filesalso worded as use smallest appropriate data types for columns
- Use LowCardinality for repeated strings16 of 609 in 6 filesalso worded as use LowCardinality for repeated string columns
- Denormalize data to avoid joins16 of 609 in 6 filesalso worded as denormalize data to avoid excessive joins
- Monitor query performance using system logs16 of 609 in 6 filesalso worded as monitor query performance using system query log
What they tell it not to do
- Do not use SELECT * in production queries35 of 609 in 29 filesalso worded as Do not use SELECT * in production; Do not use SELECT *
- Do not use FLOAT or DOUBLE for money29 of 609 in 22 filesalso worded as avoid float for money; do not use float for monetary values
- Do not use string concatenation for SQL queries21 of 609 in 20 filesalso worded as do not use string concatenation for time values; Do not use string concatenation for SQL
- do not use select star19 of 609 in 9 filesalso worded as do not use select star in queries
- Do not use deep OFFSET pagination on large tables19 of 609 in 12 filesalso worded as do not use offset for pagination on large tables; Never use OFFSET/LIMIT for large datasets
- Do not use the final keyword16 of 609 in 6 filesalso worded as do not use final keyword in queries
- Do not use TIMESTAMP without time zone16 of 609 in 15 filesalso worded as Do not use TIMESTAMP without time zone; Do not use TIMESTAMP
- Do not hardcode credentials16 of 609 in 14 filesalso worded as do not hardcode keys; Do not hardcode API credentials in processor pipelines
- Do not perform individual inserts in a loop15 of 609 in 6 filesalso worded as do not perform individual small inserts; Do not use single inserts in a loop
- Do not edit committed migration files13 of 609 in 12 filesalso worded as never edit a migration that has already run; never edit already shipped migrations
What they expect to be installed
- psql50 of 609
- PostgreSQL47 of 609
- curl34 of 609 in 30 files
- EXPLAIN34 of 609 in 25 files
- Prisma28 of 609
- docker27 of 609
- EXPLAIN ANALYZE26 of 609 in 20 files
- sqlite325 of 609
- drizzle-kit25 of 609 in 20 files
- pg_stat_statements24 of 609 in 19 files
What they ask it to produce
- Database schema67 of 609also worded as Database schema definitions; Database schema design
- Migration scripts44 of 609also worded as SQL migration scripts; versioned migration scripts
- Optimized SQL queries42 of 609 in 38 filesalso worded as Optimized database queries; Optimized query patterns
- Migration files41 of 609also worded as SQL migration files; Migration SQL files
- Query results34 of 609also worded as SQL query results; Database query results
- Database migrations27 of 609 in 23 filesalso worded as Database migration files; Database migrations with indexes
- Optimized table schemas23 of 609 in 12 filesalso worded as Optimized database schema; Optimized database schema designs
- SQL queries22 of 609also worded as Database queries; SQL query
When Databases & SQL authors say to reach for one
The situations these authors wrote into their own files, counted out of the same 609 authors, with the skills that name each one
- Designing database schemas60 of 609 in 50 files
- Optimizing query performance35 of 609 in 25 files
- Senior backend
- Clickhouse io
- Cosmosdb best practices
- Laravel database optimization
- Discover database
- and 4 more on this shelf
- Writing SQL queries28 of 609 in 25 files
- Postgres best practices
- Supabase postgres best practices
- and 26 more on this shelf
- Configuring connection pooling25 of 609 in 21 files
- Implementing Row Level Security20 of 609 in 17 files
- Postgres best practices
- Supabase postgres best practices
- Data modeling
- and 26 more on this shelf
- Writing analytical queries15 of 609 in 6 files
- Clickhouse io
- and 1 more on this shelf
- Troubleshooting slow queries15 of 609 in 14 files
- Postgres pro
- and 1 more on this shelf
- Schema15 of 609
How Databases & SQL skills are built
4,007 skill directories by 654 authors, read from their repositories’ own file trees 2026-08-05
The middle bundle among those shipping files is 3 files, 20.7 KB beside SKILL.md
Counted by distinct author, same as above, so one author publishing forty template copies counts once. SKILL.md itself is not counted as a file, so a single-file skill is one where that file is the whole skill.
The shape
- SKILL.md is the whole skill242 of 654 authors, 1,970 of 4,007 skills
- files ship beside it412 of 654 authors, 2,037 of 4,007 skills
- executable scripts ship inside144 of 654 authors, 603 of 4,007 skills
The folders they converge on
- references/283 of 654 authors, 1,165 of 4,007 skills
- scripts/120 of 654 authors, 577 of 4,007 skills
- assets/48 of 654 authors, 166 of 4,007 skills
- evals/40 of 654 authors, 65 of 4,007 skills
- agents/37 of 654 authors, 73 of 4,007 skills
- rules/25 of 654 authors, 41 of 4,007 skills
bytebase/dbhub/io.github.bytebase/dbhub MCP server
3,362★ repoMinimal, token-efficient Database MCP Server for PostgreSQL, MySQL, SQL Server, SQLite, MariaDB
mongodb-js/mongodb-mcp-server/io.github.mongodb-js/mongodb-mcp-server MCP server
1,099★ repoMongoDB Model Context Protocol Server
pgEdge/pgedge-postgres-mcp/io.github.pgEdge/postgres-mcp MCP server
211★ repoEnterprise PostgreSQL MCP server with NL queries, hybrid search (pgvector+BM25), and web UI
Idun-Group/idun-agent-platform/examples/tutorials/text-to-sql-deep-agent/skills/query-writing Skill
198★ repo🟪 Open-source runtime that ships any LangGraph or Google ADK agent as a production-ready FastAPI service. Bundled , AG-UI copilotkit API, chat UI, 15+ guardrails, MCP, OpenTelemetry, OIDC. One pip install. Self-hosted, no vendor lock-in.
ahpxex/open-dashboard/.claude/skills/add-backend Skill
119★ repoA skill catalogue of 36 copy-ready admin UI shapes an AI agent installs and composes into a real back-office. Built on TanStack Start, Drizzle + better-auth, shadcn + Tailwind v4.
AltimateAI/data-engineering-skills/skills/altimate-code Skill
118★ repoSkills related to Data Engineering Work for Claude Code
nubo-db/dynoxide/io.github.nubo-db/dynoxide MCP server
83★ repoDynamoDB-compatible database engine in Rust on SQLite, with an MCP server for coding agents.
gogf/skills/skills/goframe-v2 Skill
no license78★ repoGoFrame Agent Skills empowering AI to deeply understand GoFrame conventions and best practices, generating high-quality, production-ready code.
michtio/craftcms-claude-skills/skills/craft-cloud Skill
70★ repoProduction-ready Claude Code skills, agents, and project templates for Craft CMS 5 development
FROWNINGdev/django-orm-lens/io.github.FROWNINGdev/django-orm-lens MCP server
64★ repoDjango ORM static-analysis MCP. 10 tools: models, relations, migrations, indexes, signals, N+1.
AzureCosmosDB/cosmosdb-agent-kit/skills/cosmosdb-best-practices Skill
50★ repoA collection of skills for AI coding agents working with Azure Cosmos DB. Skills are packaged instructions and scripts that extend agent capabilities.
enessari/metabase-ai-assistant/io.github.enessari/metabase-ai-assistant MCP server
48★ repoMCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL
unmateria/MCP-Access/io.github.unmateria/msaccess-database MCP server
no license48★ repoRead and edit Microsoft Access databases (.accdb/.mdb) - forms, VBA, tables, queries. Windows.
prisma/mcp/io.prisma/mcp MCP server
no license47★ repoMCP server for managing Prisma Postgres.
Linked-API/linkedin-skills/linkedin-growth Skill
42★ repoLinkedIn automation skills for AI agents – sales, social selling, data extraction, and more.
haymon-ai/dbmcp/ai.haymon/dbmcp MCP server
30★ repoDatabase MCP server for MySQL, MariaDB, PostgreSQL & SQLite with PII redaction and write-prevention
nicholasglazer/gnosis-mcp/io.github.nicholasglazer/gnosis MCP server
27★ repoZero-config MCP server for searchable documentation. SQLite or PostgreSQL.
verygoodplugins/mcp-local-wp/io.github.verygoodplugins/mcp-local-wp MCP server
no license27★ repoWordPress database access via Local by Flywheel. Execute read-only MySQL queries and inspect schema.
PostgreSQL performance Tuner MCP Server
isdaniel/pgtuner_mcp/io.github.isdaniel/pgtuner_mcp MCP server
25★ repoprovides AI-powered PostgreSQL performance tuning capabilities.
AgamiAI/agami-core/plugins/agami/skills/agami-connect Skill
no license22★ repoThe trust layer between AI and your data. Turns your database schema - messy joins, undocumented tables, into a governed semantic model so AI answers with correct SQL and a receipt on every answer. Run it locally, or self-host a shared team server with Docker.
exmergo/dex/skills/explore Skill
21★ repoDex is the agent-native analytics engineering toolkit. Point it at your warehouse and your dbt project. It learns the landscape, authors your transformations, and tells you exactly what to fix when the schema drifts. Built for analytics engineers and data engineers who want more out of their coding agent.
Souhar-dya/mcp-db-server/io.github.Souhar-dya/mcp-db-server MCP server
no license19★ repoMCP server for SQLite, PostgreSQL, and MySQL with natural language to SQL and direct SQL tooling.
jamjet-labs/jamjet/io.github.jamjet-labs/engram-server MCP server
19★ repoDurable memory for AI agents: fact extraction, hybrid retrieval, temporal graph. SQLite/Postgres.
spences10/mcp-sqlite-tools/io.github.spences10/mcp-sqlite-tools MCP server
19★ repoMCP server for local SQLite database operations
powersync-ja/agent-skills/skills/powersync Skill
17★ repoOfficial agent skills for PowerSync
saifoelloh/golang-best-practices-skill Skill
15★Production-ready Go code review skill for AI agents based on authoritative sources
tmssoftware/skills/skills/aurelius-mapping Skill
no license14★ repoOfficial collection of agent skills from TMS Software
neverinfamous/postgresql-mcp/io.github.neverinfamous/postgres-mcp MCP server
12★ repoPostgreSQL MCP server with 203 tools, connection pooling, HTTP/SSE, OAuth 2.1, and tool filtering
neverinfamous/postgres-mcp/io.github.neverinfamous/postgres-mcp-server MCP server
12★ repoEnterprise PostgreSQL MCP server with 63 tools, 10 resources, 10 prompts for AI-native operations
HetCreep/CoalMine/plugin/skills/drift-canary Skill
11★ repoNine quality-canary skills for AI coding agents - code health, world-class rule completeness, grounding, supply chain, resilience, drift & more - plus the auto-cadence hooks that run them unprompted at session start and session end. Cross-agent, consent-gated, token-lean.
Combjellyshen/ZoteroBridge/io.github.Combjellyshen/zotero-bridge MCP server
10★ repoMCP Server for Zotero SQLite Database - collection, tagging, PDF reading and more.
neverinfamous/db-mcp/io.github.neverinfamous/db-mcp MCP server
10★ repoSQLite MCP server with OAuth 2.1, HTTP/SSE, 122 tools, and smart tool filtering
yamanidev/claude-code-configuration/skills/database Skill
9★ repoMy personal Claude Code configuration.
netresearch/composer-agent-skill-plugin/examples/database-analyzer-skill Skill
9★ repoComposer plugin enabling universal Agent Skill distribution and management for PHP projects
snss10/DBeast/io.github.snss10/dbeast MCP server
9★ repoPostgreSQL MCP server for schema, query, health, security, and performance analysis.
neverinfamous/mysql-mcp/io.github.neverinfamous/mysql-mcp MCP server
8★ repoEnterprise-grade MySQL MCP Server with OAuth 2.0, 106 tools, and Docker deployment
Alibaba java coding guidelines skill
ns3154/alibaba-java-coding-guidelines-skill Skill
7★skill for applying Alibaba Java Coding Guidelines
chemny/douyin-video-downloader Skill
7★本地优先的抖音视频、封面、直接音频和用户主页作品列表采集下载 Skill。
Read only local mysql mcp server
hovecapital/read-only-local-mysql-mcp-server/capital.hove/read-only-local-mysql-mcp-server MCP server
7★ repoMCP server for read-only MySQL database queries in Claude Desktop
alyiox/mcp-mssql/io.github.alyiox/mcp-mssql MCP server
7★ repoRead-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.
northseadl/norix-skills/adb-mysql Skill
no license6★ repo即插即用的 AI Agent 技能集合 — 飞书集成 · Mermaid 图表 · Codex 编排 · 前端设计规格
yugui923/db-connect-mcp/io.github.yugui923/db-connect-mcp MCP server
6★ repoMulti-database MCP server for PostgreSQL, MySQL, and ClickHouse
StringNLPLAB/FlexSQL/claude_harness/.claude/skills/sql-revision Skill
no license5★ repoFlexSQL: Flexible Exploration and Execution Make Better Text-to-SQL Agents
OscarDRT/supastarter-nextjs-skill/supastarter-nextjs-skill Skill
5★ repoAgent Skills–compliant skill for supastarter.
usetemi/skills/skills/fly-io Skill
5★ repoOpen-source agent skills for Claude Code, Claude Cowork, Codex, Cursor, and Gemini CLI. Connect AI agents to Google Analytics, Search Console, and Drive. From Temi (usetemi.com).
cookieMonsterDev/agents-skills/architecture-skills/database-normalization Skill
5★ repoAgent Skills for coding agents
arifulislamat/database-mcp/io.github.arifulislamat/database-mcp-libsql MCP server
5★ repoMCP server for libSQL/Turso, local or remote. Read-only by default, row caps, timeouts.
edelciomolina/postgres-mcp/io.github.edelciomolina/postgres-mcp MCP server
no license5★ repoPostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.
meringlab/string-mcp/org.string-db/string-mcp MCP server
5★ repoQuery STRING interactions, enrichment, annotations, homology, and PPI networks.
WESTsyre21/setup-backend-stack Skill
4★This skill bootstraps a local Node.js backend development stack with Docker, PostgreSQL, and an ORM (Prisma or Sequelize). It is designed to help the next user quickly install, configure, and run the skill in a Claude-compatible skill directory.
marcfargas/skills/azcli Skill
4★ repoReusable skills for AI coding agents (pi, Claude Code, Agent Skills standard)
wzszsw/easy-query-orm Skill
no license4★pilat/mcp-datalink/io.github.pilat/mcp-datalink MCP server
4★ repoMCP server for secure database access (PostgreSQL, MySQL, SQLite)
tkmawarire/sql-sentinel/io.github.tkmawarire/sql-sentinel MCP server
4★ repoSQL Server monitoring and diagnostics for AI agents using Extended Events. No ODBC drivers required.
ralvarezdev/ralvaskills/skills/databases/sql-architect Skill
3★ repoMy personal, ever-growing collection of AI skills for OpenCode and Claude Code. Enforces strict clean architecture and professional standards.
John0King/AdoMCP/io.github.John0King/adomcp MCP server
3★ repoDatabase MCP server for schema discovery, comments, and SQL queries.
MuhDur/oraclemcp/io.github.MuhDur/oraclemcp MCP server
3★ repoEngine-free, governed Oracle Database MCP server with a fail-closed SQL guard (unofficial).
Wangggym/quarry/io.github.Wangggym/quarry MCP server
3★ repoSafety-railed database access for agents: Postgres, MySQL, Redis. Read-only by default.
mimersql/mimer-mcp/io.github.mimersql/mimer-mcp MCP server
3★ repoAn MCP server with Mimer SQL Database Connectivity
ofershap/mcp-server-sqlite/io.github.ofershap/sqlite MCP server
3★ repoSQLite MCP — query databases, inspect schemas, explain queries, export data.