Fast, Private & Client-Side Developer Suite
100% Client-Side • Private
Converters

SQL Table to TypeScript Interface

Convert SQL CREATE TABLE schema definitions into type-safe TypeScript interfaces.

Loading tool...

Related Tools

Continue with SQL Formatter, JSON to TypeScript, JSON to Multi-Language Models.

SQL Formatter

Format SQL queries

JSON to TypeScript

Generate TypeScript interfaces from JSON

JSON to Multi-Language Models

Generate Go structs, Python Pydantic, Rust Serde, and C# from JSON

How to Use SQL Table to TypeScript Interface

  1. Paste your SQL `CREATE TABLE ...` statement.
  2. Optionally set a custom interface name.
  3. Copy the resulting TypeScript interface.

Frequently Asked Questions

How are SQL data types mapped to TypeScript?

INTEGER/FLOAT/DECIMAL map to number, VARCHAR/TEXT/UUID map to string, BOOLEAN maps to boolean, and TIMESTAMP/DATE map to Date | string.

Sources & References

Primary references: PostgreSQL: SQL Syntax and Lexical Structure; TypeScript Handbook: Object Types.

Review policy: references and behavior notes are checked whenever the tool implementation changes.