Database Redundancy Analyzer

Identify redundant database structures with this AI prompt, optimizing storage and performance for enterprise systems.

What this prompt does

  • Analyzes database schemas to identify redundant structures that drain performance and create maintenance issues.
  • Examines table structures for duplicate data patterns and isolated tables to ensure adherence to normalization principles.
  • Provides a comprehensive audit report with specific recommendations for consolidation or removal of redundant tables.

How to use this prompt

  1. Fill in the [PASTE YOUR COMPLETE DATABASE SCHEMA WITH TABLE DEFINITIONS], [INSERT YOUR DATABASE PLATFORM - MySQL, PostgreSQL, SQL Server, etc.], [INSERT YOUR BUSINESS DOMAIN - e-commerce, healthcare, finance, etc.], [INSERT SPECIFIC PERFORMANCE ISSUES YOU'RE EXPERIENCING], and [INSERT CURRENT DAT…
  2. Example: "My database schema includes tables for customer data, orders, and inventory. My database platform is MySQL. My primary business domain is e-commerce. I am experiencing slow query performance and high storage costs. My maintenance challenges include frequent schema updates and data integ…

Free prompt — copy, paste and run. Part of the Coding prompts collection in the God of Prompt library.

Related Coding prompts