Data

Schema Inspector

Parse and analyse database schemas. Supports JSON Schema and SQL DDL formats. Extract entities, columns, types, and constraints.

Estimated time: 1-3 min
Difficulty level: Intermediate
Privacy: Runs locally
All Data tools
5000ms CPU256MB RAM64KB in · 256KB outEducational, no sensitive data
Mode

Supports JSON Schema and SQL DDL (CREATE TABLE).

Export

Download results as PDF, CSV, or JSON.

Run the tool to enable exports.

Understanding Schemas

What is a Schema?

A schema defines the structure of data including tables, columns, data types, constraints, and relationships. It acts as a blueprint for your database or API data models.

Supported Formats

  • SQL DDL using CREATE TABLE statements with columns and constraints
  • JSON Schema using object definitions with properties and types

Common Data Types

  • SQL types such as INTEGER, VARCHAR, TIMESTAMP, DECIMAL, BOOLEAN
  • JSON types such as string, number, boolean, array, object
  • Constraints such as PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE

Schema Design Tips

Use meaningful names. Define appropriate constraints. Consider relationships between entities. Document your schema decisions. Version control your schema changes.