QuestoryAI 提示词平台QuestoryAI 提示词平台QuestoryAI 提示词平台
TeamsBotsSkillsPromptsPromptmasters
Developers
LoginRegister
CC0 2026 QuestoryAI 提示词平台
GitHub

Database Migrations taste

Opinionated preferences for writing safe, zero-downtime database schema migrations. 来源:https://prompts.chat/prompts/cmvc3cc0s0001l508tgg73kqg

F
@import-252f10c83610ebca1a059c0b
about 1 hour agoNovember 11, 2026 at 02:00 AM
Coding•BackendDatabaseSQLMigration
Schema

taste.md

Loading...

Comments (0)

Related Skills

SQL Schema Design Reviewer

Skill

Reviews PostgreSQL and MySQL tables (schema.sql, a dump or a pull request's CREATE TABLE) for design flaws that are cheap to fix before data exists - missing primary keys, money in float columns, foreign keys with mismatched types or no index, 32-bit ids, timestamps without time zone, nullable flags, free-text statuses, reserved names and case-sensitive unique emails. Returns corrected DDL. Includes a stdlib Python linter with --self-test. 来源:https://prompts.chat/prompts/cmvt899cc0015lb076u345t0n

F@import-252f10c83610ebca1a059c0b
0

SQL Index Recommendation Reviewer

Skill

Reviews a schema and slow SQL queries, proposes composite indexes in the right column order (equality, sort, range) with covering columns and tradeoffs, flags non-sargable filters like functions on columns and leading-wildcard LIKE, and warns about duplicate, redundant, and low-selectivity indexes. Use when a user shares a slow query, EXPLAIN output, or schema and asks "what index do I need?" or "too many indexes?". Includes a tested stdlib Python helper. 来源:https://prompts.chat/prompts/cmv6dyatr000bl80667elnhdv

F@import-252f10c83610ebca1a059c0b
0

Database Connection Pool Sizing Calculator

Skill

Sizes database connection pools for Postgres/MySQL apps from a short JSON of services, pods, workers, threads and pool settings - worst-case connections at autoscale max and during deploy surges vs max_connections, busy connections from rps x hold time, per-process wait odds (Erlang C), CPU and memory limits, PgBouncer client and server limits. Recommends pool sizes or proxy settings. Includes an offline stdlib Python calculator with --self-test. 来源:https://prompts.chat/prompts/cmvxi8kpe0008l508b4ttzkaq

F@import-252f10c83610ebca1a059c0b
0

Database Migration Safety Review

Skill

Reviews PostgreSQL and MySQL schema migrations (raw SQL or ORM-generated) for table locks, rewrites, data loss, and breaking changes, then proposes safe zero-downtime rewrites with a clear verdict. 来源:https://prompts.chat/prompts/cmureuo3w0001lb06x7qn6vyo

F@import-252f10c83610ebca1a059c0b
0