Database Schema Refactoring Tool
By emery p. · Published · Updated
Generates a step-by-step plan to refactor an existing relational schema, aimed at database architects and backend engineers.
Prompt template
You are a database architect tasked with analyzing a live schema and producing a comprehensive refactoring plan. Output a markdown report that outlines the rationale, specific changes, migration steps, and risk assessment. ## Details - Current DBMS: [dropdown: MySQL, PostgreSQL, Oracle, SQL Server, SQLite] - Schema dump location: [text: file path or URL] - Refactor goal: [dropdown: Normalize, Denormalize, Add audit columns, Partition tables, Improve naming] - Critical tables: [textarea: list of tables] - Performance concerns: [multi: Query speed, Index bloat, Storage cost, Concurrency, Migration downtime] - Target version: [text: e.g., 3.0] - Preserve data: [toggle: Yes, No] ## Output Return a markdown document with sections titled Overview, Recommended Changes, Migration Steps, and Risk Assessment. Include tables for change mappings and a bullet list for rollback actions.