Verified
Supabase done right. RLS policies, edge functions, realtime, auth — in idiomatic patterns.
PostgresRLSRealtime
By use case
Top Databases & Schemas Skills
PlanetScale workflows, schema design conventions, query patterns, migrations.
5 skills indexed · ranked by composite score
Top 5 Databases skills
- 1.supabase-skill—Supabase done right. RLS policies, edge functions, realtime, auth — in idiomatic patterns.
- 2.planetscale-skills—PlanetScale's schema branching and index-aware queries, packaged for agents.
- 3.prisma-orm—Prisma migrations and queries by the book. Index-aware, migration-safe, type-correct.
- 4.redis-cache-patterns—Caching without the bugs. Invalidation, write-through, cache-aside, distributed locks.
- 5.mongodb-patterns—MongoDB aggregations and indexing without the foot-guns.
About Databases & Schemas
The best agent skills for databases and schemas in 2026 handle safe migrations as well as design — flagging the NOT NULL footgun on large tables, estimating online index build impact on write-heavy loads, and covering Drizzle and Prisma ORM patterns alongside raw Postgres, MySQL, and SQLite DDL. Database & schema Skills give agents the structured workflow needed to design tables, write migrations, optimize queries, and avoid the classic footguns — N+1 queries, missing indexes, lock contention, schema drift between environments. The category covers Postgres, MySQL, PlanetScale, Supabase, SQLite, Mongo, and the increasingly common Drizzle / Prisma ORM patterns.
Common workflows include designing a schema for a new feature, writing a safe migration (NOT NULL adds, large backfills, online index builds), optimizing a slow query with EXPLAIN ANALYZE, generating an ER diagram from an existing schema, designing partitioning strategies for large tables, and reviewing migrations for safety before merge. Several Skills pair with Supabase, PlanetScale, Neon or Snowflake MCP servers for live schema inspection.
Backend engineers, data platform engineers, and product engineers shipping schema changes use these. Composite scoring weights provenance, install count, and how well the Skill handles migrations specifically — the highest-risk part of any database workflow. Skills that flag dangerous migration patterns (NOT NULL without default on large tables, online index build estimates) rank above those that just generate SQL.
Ranked by score
Best Databases Skills
Skills that do databases well — ranked transparently.
Verified
PlanetScale's schema branching and index-aware queries, packaged for agents.
SchemaMigrationsMySQL
Code
Medium4 min
Community
Prisma migrations and queries by the book. Index-aware, migration-safe, type-correct.
PrismaTypeScriptMigrations
Code
Medium3 min
Community
Caching without the bugs. Invalidation, write-through, cache-aside, distributed locks.
RedisCachePerformance
Code
Low2 min
Community
MongoDB aggregations and indexing without the foot-guns.
MongoDBAggregationNoSQL
Code
Medium3 min
FAQ
Frequently asked
Postgres, MySQL or SQLite?
The schema-design patterns largely overlap. Migration safety and operational concerns diverge sharply — Postgres has online DDL for most operations, MySQL's online DDL is narrower, SQLite mostly rewrites the table. The top Skills warn about platform-specific footguns.
Can these Skills run migrations?
They generate and review; whether the agent runs them depends on the agent and your approval. Claude Code with a Postgres MCP server can; Claude.ai web only generates.
How do they handle ORM-specific patterns?
Drizzle and Prisma have dedicated Skills that produce idiomatic schema definitions and migrations. Generic SQL Skills fall back to raw DDL.
Are these Skills useful for query optimization?
Yes — they read EXPLAIN ANALYZE output and propose index, query-shape, or schema changes. The cloud-native data warehouse Skills (BigQuery, Snowflake) are particularly useful here.
Do they catch unsafe migrations?
The top Skills flag the well-known footguns — NOT NULL on a large table without a default, multi-step migrations that need separate deploys, online index build assumptions on a write-heavy table.
Other categories
Browse other use cases
Document ProcessingFrontend & UI DesignCode Quality & ReviewTesting & QASecurity & AuditingDevOps & InfrastructureBrowser & Web AutomationData & AnalyticsMarketing & GrowthSEO & ContentVideo & MediaDiagrams & VisualizationAI/ML & Agent ToolingCommunication & DocsWorkflow OrchestrationDomains & DNSWeb Hosting & DeploysPayments & BillingEmail & MessagingAPIs & Integrations