Database AI Prompts

Geospatial Query Optimizer

Use this prompt to geospatial query optimizer with AI assistance

Temporal Table Implementation

Use this prompt to temporal table implementation with AI assistance

Upsert Pattern Generator

Use this prompt to upsert pattern generator with AI assistance

Data Type Selection Guide

Use this prompt to data type selection guide with AI assistance

Database Connection Pooling Advisor

Use this prompt to database connection pooling advisor with AI assistance

Trigger and Function Auditor

Use this prompt to trigger and function auditor with AI assistance

Recursive CTE Query Builder

Use this prompt to recursive cte query builder with AI assistance

Composite Index Design Helper

Use this prompt to composite index design helper with AI assistance

Database Vacuum and Maintenance Plan

Use this prompt to database vacuum and maintenance plan with AI assistance

Data Archival Strategy

Use this prompt to data archival strategy with AI assistance

Database Monitoring Dashboard Queries

Use this prompt to database monitoring dashboard queries with AI assistance

Materialized View Refresh Strategy

Use this prompt to materialized view refresh strategy with AI assistance

JSON Column Query Optimizer

Use this prompt to json column query optimizer with AI assistance

Database Replication Setup Guide

Use this prompt to database replication setup guide with AI assistance

Database Index Strategy Audit

Use this prompt to database index strategy audit with AI assistance

Stored Procedure Generator

Use this prompt to stored procedure generator with AI assistance

Query Result Caching Strategy

Use this prompt to query result caching strategy with AI assistance

Database Normalization Advisor

Use this prompt to database normalization advisor with AI assistance

Row-Level Security Policy Generator

Implement PostgreSQL Row-Level Security for multi-user data isolation

Full-Text Search Implementation

Implement fast full-text search using PostgreSQL without external tools

Database Migration Script Writer

Generate safe, reversible database migration scripts

Database Schema Designer

Design a normalized database schema from application requirements

Design a database sharding strategy with shard key selection, routing logic, and migration plan from a single database

Use this prompt to database permission matrix with AI assistance

Use this prompt to slow query log analyzer with AI assistance

Use this prompt to database schema documentation generator with AI assistance

Use this prompt to read replica configuration guide with AI assistance

Use this prompt to foreign key relationship mapper with AI assistance

Use this prompt to database seed data generator with AI assistance

Use this prompt to etl pipeline designer with AI assistance

Use this prompt to database partitioning planner with AI assistance

Design efficient time-series schemas for analytics and monitoring data

Configure and optimize database connection pooling for high-traffic applications

Optimize slow SQL queries with explain analysis