CODE⚡ 8K uses📋 GPT-4, Gemini
SQL Query Generator
Generate optimized SQL queries.
SQL for [TASK] on [DB] with tables [TABLES] relationships [RELATIONSHIPS] conditions [CONDITIONS] output [OUTPUT] optimizing for [OPTIMIZATION]. JOIN types (justified), sargable WHERE, window functions, CTEs, EXPLAIN plan, index recommendations.
Variables
TASKDBTABLESRELATIONSHIPSCONDITIONSOUTPUTOPTIMIZATION
CODE⚡ 7K uses📋 GPT-4, Claude
Database Schema Designer
Design normalized schemas.
Schema for [APPLICATION_TYPE] entities [ENTITIES] relationships [RELATIONSHIPS] in [DB] at [SCALE] scale. ER diagram (text), CREATE TABLE, PK/FK, indexes, normalization 1NF-3NF, migrations, seed data.
Variables
APPLICATION_TYPEENTITIESRELATIONSHIPSDBSCALE
CODE⚡ 5K uses📋 GPT-4, Claude
Prisma Schema Generator
Generate Prisma schemas.
Prisma for [APP] models [MODELS] relations [RELATIONS] on [DB]. schema.prisma (models, enums, relations, indexes, compound keys), generated client, migration commands, seed script, queries.
Variables
APPMODELSRELATIONSDB
CODE⚡ 4K uses📋 GPT-4
Data Migration Script
Write safe migrations with rollback.
Migration for [CHANGE_DESCRIPTION] on [DB] from [SOURCE_TABLE] to [TARGET_TABLE] with rules [TRANSFORMATION_RULES]. Up migration, down migration, data backfill (batched + progress), validation queries, tests.
Variables
CHANGE_DESCRIPTIONDBSOURCE_TABLETARGET_TABLETRANSFORMATION_RULES
TEXT⚡ 4K uses📋 GPT-4, Gemini
Database Index Strategy
Design optimal indexing strategies.
Index strategy for [DB] with tables [TABLES] and query patterns [QUERIES]. Types: B-tree, hash, GiST, GIN, BRIN (per use case). Composite index design, covering indexes, partial indexes, index maintenance (bloat, reindex), monitoring (unused, duplicate). Expected performance gain: [GAIN]%.
Variables
DBTABLESQUERIESWORKLOAD
TEXT⚡ 4K uses📋 GPT-4, Claude
Event Sourcing Schema
Design event sourcing databases.
Event sourcing schema for [APP] with events [EVENTS]. Tables: event_store (aggregate_id, version, event_type, data, metadata, timestamp), snapshots, projections. Commands, events, and query models. CQRS pattern integration. Event versioning strategy.
Variables
APPEVENTSLANGUAGE