Stats
Actions
Tags
From ai-agent-kit
Use when modifying SQL or NoSQL schemas, migrations, queries, indexes, data access layers, transactions, or anything touching persistence. Covers Postgres, MySQL, SQLite, MongoDB, Redis, and ORM patterns (EF Core, Prisma, SQLAlchemy, sqlx, Drizzle, TypeORM, GORM).
How this skill is triggered — by the user, by Claude, or both
Slash command
/ai-agent-kit:database**/*.sql**/migrations/****/schema.prisma**/prisma/**This skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Persistence that is safe under load, evolves without downtime, and doesn't
Persistence that is safe under load, evolves without downtime, and doesn't surprise the team six months later. Schema is a contract: changes are versioned, reviewed, and reversible.
| Concept | Best practice |
|---|---|
| Schema | Normalise to 3NF, choose correct types, use UUIDs/ULIDs for public IDs |
| Indexes | Add indexes on foreign keys, filter fields, and join columns; avoid over-indexing |
| ORM | Avoid N+1 query patterns, use eager loading, run migrations in transactions |
| Key commands | Postgres: EXPLAIN ANALYZE <query>, pg_dump -U <user> -d <db> |
Extended how-to, patterns, anti-patterns, and checklists: SKILL.deep.md
Load these only when signals justify it:
| Reference | Load when |
|---|---|
references/sql-server.md | Task targets Microsoft SQL Server / Azure SQL specifically. Task text mentions SQL Server, T-SQL, MSSQL, sqlcmd, stored procedure, clustered index, deadlock, isolation level. **/*.sql changes carrying an EF Core / dotnet signal. |
Fetches up-to-date documentation from Context7 for libraries and frameworks like React, Next.js, Prisma. Use for setup questions, API references, and code examples.
Applies a firm's KYC/AML rules grid to parsed onboarding records: assigns risk rating, checks required documents, outputs rule outcomes with citations, and routes for escalation.
Generates daily or weekly digests of activity from connected sources (chat, email, docs, tasks, CRM), highlighting action items, decisions, mentions, and project updates.
npx claudepluginhub petrovc/ai-agent-kit --plugin ai-agent-kit