Include regression tests that encode CURRENT behavior BEFORE the rewrite
提示词编程开发222026年9月21日Python Production Script / CLI Generator
Generates a robust Python CLI with argparse, logging, retries, dry-run, and typed config — ideal for automation, data pipelines, and internal ops scripts.
提示词编程开发252026年9月21日React / Next.js Component + Page Builder
Builds accessible, typed React components with loading/error/empty states, server-client boundary decisions (Next.js App Router), and responsive styles.
提示词网站开发312026年9月21日REST API Designer + Implementer
Produces a consistent, versioned REST API: OpenAPI spec first, then implementation, auth, rate limits, idempotency, and docs. Great for new services.
提示词编程开发282026年9月21日GraphQL API & Resolver Builder
For designing GraphQL schemas without over-fetching pitfalls: pagination, dataloaders, auth in resolvers, n+1 prevention, and persisted queries.
提示词编程开发232026年9月21日Schema design: nouns as types, verbs as mutations; use the Relay connection
提示词编程开发262026年9月21日Enumerate queries/mutations with auth requirements in a table. Enforce auth
提示词编程开发242026年9月21日Prevent N+1 with DataLoader per request; batch and cache; show the batching
提示词编程开发252026年9月21日Provide dataloaders, resolvers, generated types, context (with auth/prisma),
提示词编程开发272026年9月21日Database Schema & SQL Expert
Designs schemas (normalization, indexes, constraints) and writes/optimizes SQL. Use before coding features that touch the database.
提示词编程开发252026年9月21日ER model in text (entities, attributes, types, nullability, PK/FK, cardinalities,
提示词编程开发242026年9月21日DDL with: correct types (bigint identity, timestamptz, jsonb vs columns),
提示词编程开发222026年9月21日Multi-tenancy strategy comparison (shared schema + tenant_id vs schema-per-tenant)
提示词编程开发212026年9月21日The 8 most important queries as SQL with EXPLAIN ANALYZE expectations; write
提示词编程开发252026年9月21日Migration plan: expand/contract (additive, backfill, switch, drop) with
提示词编程开发252026年9月21日SQL Query Debugger & Optimizer
Paste a slow query and get a diagnosis, rewritten SQL, and index recommendations with EXPLAIN-based reasoning.
提示词编程开发222026年9月21日Read the plan bottom-up; identify the dominant cost (seq scans, bad estimates,
提示词编程开发252026年9月21日Point out stale statistics or planner mis-estimates and the ANALYZE/VACUUM
提示词编程开发242026年9月21日Rewrite the query (CTEs vs subqueries, join order, semi-joins with EXISTS,
提示词编程开发272026年9月21日Provide exact CREATE INDEX statements (with CONCURRENTLY) and predict the
提示词编程开发222026年9月21日