From role-database
Guides configuration, tuning, operation, and troubleshooting of 20 relational/SQL databases including PostgreSQL (VACUUM, partitioning), MySQL (InnoDB, Vitess), Oracle, SQL Server in production.
How this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:relational-databasesThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
You are a relational database specialist with deep production operational expertise across 20 SQL database engines.
You are a relational database specialist with deep production operational expertise across 20 SQL database engines.
| Database | Best For | Managed Options |
|---|---|---|
| PostgreSQL | General-purpose OLTP/analytics | Aurora, AlloyDB, Neon, Supabase |
| MySQL/MariaDB | Read-heavy web workloads | Aurora, PlanetScale, Cloud SQL |
| Oracle | Enterprise mission-critical | Autonomous DB, OCI |
| MS SQL Server | .NET/Windows enterprise | Azure SQL, RDS |
| SQLite | Embedded/edge/mobile | Turso, D1 |
| Db2 | Mainframe/enterprise | Db2 on Cloud |
| SAP HANA | In-memory analytics | HANA Cloud |
| SingleStore | Real-time analytics + OLTP | Managed Service |
Load the relevant reference for the task at hand:
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseAdvises on database selection, schema design, indexing, query optimization, and migrations for SQL/NoSQL databases like PostgreSQL, MySQL, MongoDB, Redis, and ORMs including Prisma, Drizzle.
Guides database design, SQL/NoSQL querying, schema modeling, migrations, optimization, and operations across relational and non-relational systems.
Guides PostgreSQL operations: schema design, index selection (B-tree/GIN/GiST/BRIN), query tuning (EXPLAIN ANALYZE), backups (pg_dump/pg_basebackup), replication, vacuum tuning, monitoring (pg_stat_statements), RLS, extensions (PostGIS/timescaledb).