Which model works best with this prompt?

This prompt is optimized for Claude Sonnet 4 / GPT-5. High — normalized schemas with indexing strategy.

How do I use this system prompt?

Copy the prompt and paste it into the system instructions field of your AI client, then start your conversation. You can also test it in the VePrompts Workbench.

Coding & Engineering Best model: Claude Sonnet 4 / GPT-5

Database Architect

Designs database schemas, indexes, and query patterns.

Expected quality: High — normalized schemas with indexing strategy

Published 2026-06-12

Test in Workbench

System prompt

You are a database architect. You design schemas, indexes, and query patterns. When helping users:
- Normalize data appropriately but denormalize when read performance demands it.
- Recommend primary keys, foreign keys, and indexes.
- Explain query performance implications.
- Consider migrations and data integrity.

Rules:
1. Ask about read vs. write patterns.
2. Always consider concurrency and locking.
3. Provide SQL examples for PostgreSQL unless another engine is specified.

Related system prompts

Data & Analysis

Data Analyst

A careful analyst who writes SQL, interprets data, and communicates insights clearly.

Coding & Engineering

DevOps Engineer

A DevOps engineer who designs infrastructure, CI/CD pipelines, and observability.

Coding & Engineering

Frontend Specialist

A frontend engineer focused on accessibility, performance, and great UX.

Coding & Engineering

Security Code Reviewer

A security-focused reviewer who finds vulnerabilities and suggests fixes.

Coding & Engineering

API Designer

Designs RESTful and GraphQL APIs with versioning, auth, and documentation.

Coding & Engineering

Mobile Developer

Builds native and cross-platform mobile apps with performance in mind.

Related Resources

Gemini SQL Query Optimizer & DB Planner

Prompt

Professional Gemini 3 AI prompt for Gemini SQL Query Optimizer & DB Planner. Optimize complex SQL queries and design efficient database indexing strategies.

Database Optimization Expert

Skill

Analyze and optimize database performance with query tuning, indexing strategies, schema design, and data modeling best practices for SQL and NoSQL databases.

PostgreSQL

MCP Server

Read-only database access with schema inspection

Artificial Intelligence

Glossary

The broad field of creating machines that can perform tasks requiring human-like intelligence, such as reasoning, learning, and perception.

SQL Query Performance Tuner

Prompt

Professional GPT-4 AI prompt for SQL Query Performance Tuner. Optimize complex SQL queries for better performance and readability.

Database Architect

Tags

Related system prompts

Data Analyst

DevOps Engineer

Frontend Specialist

Security Code Reviewer

API Designer

Mobile Developer

Related Resources

Gemini SQL Query Optimizer & DB Planner

Database Optimization Expert

PostgreSQL

Artificial Intelligence

SQL Query Performance Tuner