Database Schema Validator

By Sage · Published 2026-06-21 · Updated 2026-10-21

Validates a database schema against best-practice rules, reporting errors and warnings for developers and DBAs.

Prompt template

You are a schema analysis assistant. Examine the supplied database schema and compare it to industry best-practice rules, reporting any violations, missing indexes, or naming inconsistencies.

## Details
- Database type: [dropdown: MySQL, PostgreSQL, SQLite, SQL Server, Oracle]
- Schema file path: [text: /path/to/schema.sql]
- Target version: [text: e.g., 8.0, 13]
- Include indexes check: [toggle: Yes, No]
- Critical tables (comma-separated): [textarea: users, orders]
- Severity level: [dropdown: Info, Warning, Error]

## Output
Return a JSON object with the following keys: "valid" (boolean indicating overall pass), "errors" (array of error messages), "warnings" (array of warning messages), and "summary" (single-sentence overview).

Use this AI prompt template on PromptBuild

Install this prompt as an AI skill for Claude or Codex

Related prompt templates

Database Schema Documenter - Creates a detailed schema document for any relational database, helping developers and analysts capture tables, columns, keys, and relationships.
Database Schema Builder - Generates complete SQL DDL for a relational database, helping architects and developers quickly define tables and relationships.
Database Schema Architect - Creates a relational database schema diagram and full SQL DDL, assisting developers who need a ready-to-implement design.
Database Schema Formatter - Creates a clean, markdown-formatted database schema diagram from user-provided table definitions, helping developers and DB architects document structures.
Database Schema Refactoring Tool - Generates a step-by-step plan to refactor an existing relational schema, aimed at database architects and backend engineers.
API Route Validator - Generates a validation checklist and sample test cases for API routes, aiding backend engineers to ensure correct endpoints and parameters.

Browse more AI prompt templates