Topic · Databases
Best database administration skills for Claude Code, Codex and other agents.
- skills
- 273
- official
- 22
Database administration skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | 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 |
| 2 | Guide for creating and maintaining outbox-based eventually consistent operations in Sentry. | getsentry/ | 45k | — | ~4.8k | Automated safety check: Pass | Unknown | today |
| 3 | Analyze a reference video frame by frame and turn its visual grammar, story beats, dialogue, product reveal, proof sequence, and conversion structure into a production-ready ecommerce story-ad… | Jingyi-Wu-Richael/ | 106 | 1 repo | ~1.6k | Automated safety check: Pass | No licence | 1 mo ago |
| 4 | Indexes reference files on Postgres schema design, indexing, partitioning, query patterns, MVCC and VACUUM, and PlanetScale-specific operations. | planetscale/ | 698 | 3 repos | ~1.8k | Automated safety check: Pass | MIT | yesterday |
| 5 | A skill your agent uses when writing, editing, reviewing, validating, or explaining Unreal Engine C++ reflected declarations: UCLASS, USTRUCT, UENUM, UINTERFACE, UPROPERTY, UFUNCTION, UPARAM, UMETA… | fjz13/ | 1.1k | — | ~1.4k | Automated safety check: Pass | Unknown | 4 mo ago |
| 6 | 6.Digoal Portable digital employee distilled from digoal's personal blog for PostgreSQL, PolarDB, DuckDB, AI+database, vector/RAG, database operations, source-code reading, technical content creation… | digoal/ | 8.6k | — | ~2.2k | Automated safety check: Pass | GPL-2.0 | 9 days ago |
| 7 | Runs read-only lookups - list, describe, get - against a live YugabyteDB Anywhere control plane using the yba CLI, with mutating commands explicitly off-limits. | yugabyte/ | 11k | — | ~1.1k | Automated safety check: Pass | Unknown | today |
| 8 | Read, decrypt, query, search, and export local WeCom/企业微信 5.x desktop databases on macOS into a private read-only vault. | mcncarl/ | 4.3k | — | ~1.3k | Automated safety check: Pass | Unknown | 3 days ago |
| 9 | PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with… | 2025Emma/ | 23k | 1 repo | ~19k | Automated safety check: Pass | MIT | 9 mo ago |
| 10 | A skill your agent uses when managing Alibaba Cloud Simple Application Server (SWAS OpenAPI 2020-06-01) resources end-to-end, including querying instances, starting/stopping/rebooting, executing… | cinience/ | 397 | 1 repo | ~1.9k | Automated safety check: Pass | MIT | 1 mo ago |
| 11 | 11.Pest Testing A skill your agent uses for Pest PHP testing in Laravel projects only. | liberusoftware/ | 112 | 1 repo | ~1.8k | Automated safety check: Pass | MIT | 2 days ago |
| 12 | 12.Mail Time A skill your agent uses when building, wiring, reviewing, or debugging MailTime and ostrio:mailer email queues for horizontally scaled Node.js, Bun, or Meteor apps. | veliovgroup/ | 143 | — | ~1k | Automated safety check: Pass | BSD-3-Clause | 6 days ago |
| 13 | Inspects, queries and carefully modifies the MoviePilot SQLite or PostgreSQL database through a bundled script that reads connection settings itself, without needing the password in the prompt. | jxxghp/ | 12k | — | ~7.1k | Automated safety check: Pass | GPL-3.0 | today |
| 14 | Guides and best practices for working with Lakebase Postgres, the database behind Neon. | smontlouis/ | 171 | 1 repo | ~2.3k | Automated safety check: Notes | GPL-3.0 | today |
| 15 | 15.Reproduce End-to-end paper reproduction from arxiv URL through smoke runs to replication experiments. | fcakyon/ | 414 | — | ~1.1k | Automated safety check: Pass | MIT | 21 days ago |
| 16 | 16.Sea Orm 2 Expert guidance for SeaORM 2.0, Rust's async ORM with strongly-typed columns, nested ActiveModels, Entity Loader API, and entity-first workflow. | FlyinPancake/ | 112 | — | ~2.9k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 17 | 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 |
| 18 | Read live production data from Bike Index through the admin OAuth token — Sidekiq and PgHero status, and the user-submitted bug reports — the same data as the cookie-gated dashboards, but… | bikeindex/ | 308 | — | ~1.9k | Automated safety check: Notes | AGPL-3.0 | today |
| 19 | 19.DB Ops Sop Database operations runbook — backup, recovery, performance tuning, troubleshooting. | OpenDCAI/ | 406 | — | ~388 | Automated safety check: Pass | Apache-2.0 | 17 days ago |
| 20 | Image-to-code replication pipeline. An agent skill from Yu-369/VibeCurb. | Yu-369/ | 980 | — | ~8.7k | Automated safety check: Pass | MIT | 2 mo ago |
| 21 | Guides and best practices for working with Lakebase Postgres, the database behind Neon. | usenotra/ | 255 | — | ~4.1k | Automated safety check: Notes | AGPL-3.0 | today |
| 22 | 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 |
| 23 | SPD V1 Batch. An agent skill from flaqai/backlink_skills. | flaqai/ | 750 | — | ~1.7k | Automated safety check: Pass | MIT | 13 days ago |
| 24 | Guide for setting up thread-safe database connection pooling (FireDAC / UniDAC) in multithreaded Horse applications. | HashLoad/ | 1.4k | — | ~1.4k | Automated safety check: Pass | MIT | today |
| 25 | Back up the memorains production database and download the dump to the local backups/ directory. | redTreeOnWall/ | 124 | — | ~565 | Automated safety check: Pass | MIT | 2 days ago |
| 26 | Guides scalability and performance work for VeloxDB's Tauri + Rust PostgreSQL backend and React + TanStack frontend. | veloxbase/ | 646 | — | ~1.7k | Automated safety check: Pass | MIT | 7 days ago |
| 27 | A skill your agent uses when designing a test plan for a distributed or stateful system — anything with persistence, replication, consensus, retries, idempotency, async messaging, multi-tenancy, or… | shenli/ | 231 | — | ~7k | Automated safety check: Pass | MIT | 2 mo ago |
| 28 | 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 |
| 29 | 29.Referee2 Systematic audit and review by Referee 2. An agent skill from scunning1975/MixtapeTools. | scunning1975/ | 469 | 2 repos | ~2.4k | Automated safety check: Pass | No licence | 1 mo ago |
| 30 | Generates complete CRUD modules for NestJS applications with Drizzle ORM. | giuseppe-trisciuoglio/ | 355 | — | ~1.3k | Automated safety check: Notes | MIT | 27 days ago |
| 31 | 31.Elodin DB Work with Elodin-DB, the time-series telemetry database. An agent skill from elodin-sys/elodin. | elodin-sys/ | 547 | — | ~2.8k | Automated safety check: Pass | Apache-2.0 | today |
| 32 | Guide to deploying and running the Skill Base server with npx or Docker: startup options, data directory, port and base path, and SQLite database backup. | ginuim/ | 120 | — | ~1.4k | Automated safety check: Pass | No licence | 15 days ago |
| 33 | Redis Cluster and replication guidance covering hash tags for multi-key operations, avoiding CROSSSLOT errors, and reading from replicas to scale read-heavy workloads. | redis/ | 165 | 1 repo | ~1k | Automated safety check: Pass | MIT | 29 days ago |
| 34 | 34.DB Admin PostgreSQL database administration — backup/restore (pgdump, PITR, WAL archiving), health monitoring (connections, bloat, cache hit ratio, dead tuples), connection pooling (PgBouncer), replication… | EliasOulkadi/ | 114 | — | ~2k | Automated safety check: Notes | MIT | 2 days ago |
| 35 | 35.Influence Cialdini's seven principles of compliance (the classic six — reciprocation, commitment-consistency, social proof, liking, authority, scarcity — plus Unity, added 2016) and Pre-Suasion. | getagentseal/ | 721 | — | ~3.8k | Automated safety check: Pass | MIT | today |
| 36 | 36.CI Speedup Cuts the wait from push to green by measuring a pipeline's critical path from run timestamps, then splitting, sharding, trimming setup and sharing test module state, with a before/after ledger. | mblode/ | 142 | — | ~2.4k | Automated safety check: Pass | MIT | yesterday |
| 37 | Redis client and connection guidance covering connection pooling, multiplexing, pipelining, client-side caching with RESP3, avoiding slow commands (KEYS, SMEMBERS, HGETALL), and tuning socket… | redis/ | 165 | 1 repo | ~1.3k | Automated safety check: Pass | MIT | 29 days ago |
| 38 | Current Bun test runner guidance for discovery, isolation, parallelism, sharding, changed tests, mocks, timers, snapshots, coverage, DOM Testing Library, and integration teardown. | shepherdjerred/ | 112 | — | ~2k | Automated safety check: Pass | GPL-3.0 | today |
| 39 | 39.DB Sculptor Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and… | EliasOulkadi/ | 114 | — | ~3.1k | Automated safety check: Notes | MIT | 2 days ago |
| 40 | Designing Data-Intensive Applications (DDIA) distilled reference guide by Martin Kleppmann. | luoling8192/ | 173 | — | ~4.7k | Automated safety check: Pass | MIT | 6 mo ago |
| 41 | Adds PyTorch FSDP2 (fullyshard) to training scripts with correct init, sharding, mixed precision/offload config, and distributed checkpointing. | Orchestra-Research/ | 13k | 2 repos | ~2.7k | Automated safety check: Pass | MIT | 3 mo ago |
| 42 | Describe model or operator HIR with TileFoundry, inspect topology and placement, run static cost analysis, visualize authored dataflow, and check a runtime implementation against its evaluator. | sablin39/ | 144 | — | ~3.4k | Automated safety check: Pass | No licence | 22 days ago |
| 43 | Read, decompose, and analyze IEEE-style papers using routed technical-reading workflows. | CloudWave818/ | 353 | — | ~591 | Automated safety check: Pass | MIT | 1 mo ago |
| 44 | In-memory caching in Golang using samber/hot — eviction algorithms (LRU, LFU, TinyLFU, W-TinyLFU, S3FIFO, ARC, TwoQueue, SIEVE, FIFO), TTL, cache loaders, sharding, stale-while-revalidate, missing… | samber/ | 3.4k | — | ~2k | Automated safety check: Pass | MIT | 6 days ago |
| 45 | Queries MySQL or MariaDB databases declared in .env by label, read-only by default unless a connection explicitly allows writes. | evolution-foundation/ | 544 | — | ~1.9k | Automated safety check: Notes | Unknown | 4 mo ago |
| 46 | A skill your agent uses when a result is surprising, impossible, contradicts a sanity check, a pipeline fails, a model won't converge, or a replication fails - before adjusting anything | K-Dense-AI/ | 348 | — | ~1.9k | Automated safety check: Pass | Unknown | 24 days ago |
| 47 | Create custom external web service APIs for Moodle LMS. An agent skill from davila7/claude-code-templates. | davila7/ | 32k | 7 repos | ~4.6k | Automated safety check: Pass | MIT | today |
| 48 | JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions, HikariCP connection pooling, Flyway migrations, and repository pattern. | affaan-m/ | 274k | 4 repos | ~5.5k | Automated safety check: Pass | MIT | 2 days ago |
Questions, answered from the data.
What is the best database administration skill?
MySQL Schema and Query Tuning (official) from planetscale/database-skills ranks first of the 273 database administration skills listed here, with the highest score: its repository has 698 GitHub stars, 3 other GitHub owners carry a copy, its SKILL.md loads about 1.4k tokens and it passes the automated safety check with no findings. Next come Hybrid Cloud Outboxes and Replicate Video Ad.
Which database administration skills are official?
22 of the 273 database administration skills are official, published by the vendor's own GitHub organization: MySQL Schema and Query Tuning, Hybrid Cloud Outboxes, PlanetScale Postgres Playbook, PlanetScale Neki Overview, Vitess for PlanetScale and 17 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.