←Leaderboard/Databases/database-skills
Last commit on October 6, 2026·Created on February 18, 2026

planetscale/database-skills

“Technical guidance for optimizing schema design, query performance, and database operations.”
Combined rank
#495
across all skills
In Databases
#3
category rank
Stars
717
+1.0% in last 7d
Forks
66
+6.5% in last 7d
Watchers
3
0.0% in last 7d
Traction scoreGitHub stars can be faked, so popularity alone can be misleading. Traction Score looks for broader signs of recent attention, adoption, and active maintenance.
TL;DR

This collection provides specialized knowledge for managing MySQL and PostgreSQL environments. It assists database administrators and developers in refining indexing strategies, tuning queries, and diagnosing locking behavior to ensure stable performance.

The skills focus on the practicalities of database maintenance, from planning migrations and schema changes to troubleshooting replication and connection issues.

WHO IT'S FOR
Database Administrators
diagnosing slow or locking database behavior
Backend / infrastructure engineers
planning database migrations and schema changes
AI agent / automation builders
integrating database optimization into AI workflows
Technical leads / architects
scaling Postgres via sharding and topology design
Repository contents

4 skill files

Compatible AgentsThe repository documents support for these agents. The skills may also work with other agents that can load SKILL.md files, but they may need some setup or small changes.

Use this skill collection

Follow the documented setup, then try a first task.

Setup

Install repository with skills.sh

Installs: Database Skills repository bundle, covering the skills under skills/.

  1. Run the documented repository installation command in a terminal.

    npx skills add planetscale/database-skills
README.md ↗ · Checked Oct 18, 2026

Give it something to do.

Suggested first task

Review one slow MySQL query

Uses mysql

  • One slow SQL query, relevant table definitions, existing indexes, and EXPLAIN output.
  • MySQL version, hosting platform, read/write mix, approximate data volume, and latency target.
Use the mysql skill to review the slow query, table definitions, indexes, and EXPLAIN output I provide. Identify the main performance concern and propose the smallest query or index change, explaining trade-offs and how to validate it. Consider my MySQL version, hosting platform, workload, data volume, and latency target.
skills/mysql/SKILL.md ↗ · Checked Oct 18, 2026
Suggested first task

Check one query for cross-shard costs

Uses vitess

  • One SQL query and the relevant table definitions.
  • Relevant VSchema, vindex columns, and keyspace sharding configuration.
Use the vitess skill to review one query against my sharded tables and VSchema. Explain whether its predicates support single-shard routing, flag cross-shard joins or aggregation costs, and suggest one small improvement based on the supplied query and routing configuration.
skills/vitess/SKILL.md ↗ · Checked Oct 18, 2026
Suggested first task

Review a Neki transaction for shard safety

Uses neki

  • One transaction's SQL, including session settings and their order relative to BEGIN.
  • Relevant data topology, shard keys, and shard group or shard index configuration.
Use the neki skill to review the transaction SQL, session settings, and data topology I provide. Check whether the transaction stays on one shard, identify assumptions about cross-shard atomicity or shared snapshots, and flag incorrect __neki.* setting names or settings applied after BEGIN. Recommend the smallest correction without executing changes.
skills/neki/SKILL.md ↗ · Checked Oct 18, 2026