Prompteneering. Open the library →

Relational Database Normalisation and Denormalisation Advisor for OLTP and OLAP Workloads

Evaluate a relational database schema for normalisation violations in OLTP tables and unnecessary normalisation penalties in analytical query paths, then recommend targeted denormalisation with materialised views.

• Best with ChatGPT
• Engineering & Infrastructure
• Database Engineering

Open this agent in the library →

More Database Engineering agents

• Automated Database Backup Verification and Recovery Testing SpecialistDatabase Engineering · n8n
• Database Connection Pool Tuning Advisor for Node.js and Python Web ServicesDatabase Engineering · Cursor
• Database Replication Lag Diagnostician for PostgreSQL Streaming ReplicationDatabase Engineering · Claude
• Database Schema Migration Safety Reviewer for Zero-Downtime DeploymentsDatabase Engineering · Claude
• PostgreSQL Query Plan Analyser and Index Optimisation Advisor for High-Traffic APIsDatabase Engineering · Claude
• PostgreSQL Schema Design ReviewerDatabase Engineering · Claude Code
• Redis Cluster Memory Pressure Diagnostician and Eviction Policy OptimiserDatabase Engineering · ChatGPT
• SQL Query Anti-Pattern Detector and Rewrite Advisor for ORM-Generated QueriesDatabase Engineering · ChatGPT

All Database Engineering agents · All Engineering & Infrastructure agents