Skip to content
TelugupalakaAITelugupalakaAI

SQL Schema to TypeScript / JSON

Generate type-safe TypeScript interfaces and JSON schemas directly from your SQL database tables.

  • Runs in your browser
  • Free, no sign-up
  • No uploads

SQL CREATE TABLE Statement

TypeScript Types

How to use the SQL Schema to TypeScript / JSON

  1. 1

    Paste your SQL CREATE TABLE statement.

  2. 2

    Click Convert SQL to generate interfaces.

  3. 3

    Switch between TypeScript, JSON Schema, and Mock JSON data tabs.

Features

Type Mapping
Maps INT, VARCHAR, NUMERIC, BOOLEAN, and TIMESTAMP to TypeScript types.
Nullability Detection
Marks optional columns with '?' based on NOT NULL constraints.

Frequently asked questions

Which SQL dialects are supported?

PostgreSQL, MySQL, SQLite, and Microsoft SQL Server table definitions.