All Tools About Blog Code Examples MCP Server — Use tools from AI agents
Workflows Paste Anything — Smart Detector Tool Pipeline Builder Bulk / Batch Processor
JSON Tools JSON Formatter & Beautifier JSON Validator JSON to CSV Converter JSON to TypeScript Generator JSON to Python Converter JSON Flatten & Unflatten jq Playground — JSON Processor JSON Mock Data Generator JSON Schema Validator JSONPath Evaluator JSON Schema Generator JSON Patch / Diff Generator
Encoding Tools Base64 Encoder / Decoder URL Encoder / Decoder Hash Generator (MD5/SHA) JWT Decoder HTML Entity Encoder / Decoder Image to Base64 Converter String Escape / Unescape Tool ASCII / Binary / Hex Converter Protobuf Decoder — Wire Format Viewer Encoding Detective — Mojibake Repair
Formatters HTML Beautifier XML Formatter & Validator SQL Formatter & Beautifier CSS Minifier & Beautifier JavaScript Minifier & Beautifier TOML Formatter & Converter YAML Formatter, Validator & Minifier
Generators UUID Generator Password Generator QR Code Generator Lorem Ipsum Generator Cron Expression Generator chmod Calculator Slug / URL Generator .gitignore Generator
Testing Tools Regex Tester Regex Explainer — Plain English
Security Tools HMAC Generator Content Security Policy Generator SSH Key Generator SSL Certificate Decoder CORS Header Builder & Generator
Design Tools Color Picker & Converter Placeholder Image Generator SVG Path Editor & Visualizer
Comparison Tools Diff Checker / Text Compare .env Diff & Merge
Converters JSON-YAML Converter Epoch / Unix Timestamp Converter Markdown to HTML Preview Curl to Fetch/Axios Converter Tailwind CSS Converter OpenAPI to TypeScript Text Case Converter Number Base Converter CSV Viewer & Editor Date & Time Format Converter SQL to MongoDB & N1QL Converter Semver Calculator & Comparator Byte / Size Calculator URL Parser & Builder Glob to Regex Converter Math Expression Evaluator SQL DDL to TypeScript Converter Duration / Time Calculator CSS Unit Converter — px, rem, em, pt, vw, vh JSON to Go Struct Converter HTML to Markdown Converter CSV to SQL Converter SQL to ORM Converter
Reference HTTP Status Code Explorer Git Command Builder GraphQL Schema Explorer MIME Type Lookup
Text Tools Word & Character Counter Text Line Sorter, Deduplicator & Tools
Networking Tools Subnet / CIDR Calculator
DevOps Tools Nginx Config Generator Docker Compose Validator Robots.txt Generator & Validator GitHub Actions YAML Validator

SQL DDL to TypeScript Converter

Convert SQL CREATE TABLE statements to TypeScript interfaces. Maps SQL types to TS types, handles nullable columns, arrays, JSON, and UUIDs.

Your data never leaves your browser Available via MCP
Next steps
SQL Formatter → JSON → TypeScript → OpenAPI → TS → Schema Generator →

How to Use

  1. Paste your SQL CREATE TABLE statements into the left panel.
  2. Optionally toggle Optional for nullable fields to use ? syntax.
  3. Click Convert to TypeScript.
  4. Copy the generated interfaces with the Copy button.

Type Mapping Reference

  • INT, SERIAL, BIGINT, FLOAT, DECIMAL → number
  • VARCHAR, TEXT, CHAR, UUID → string
  • BOOLEAN, BOOL → boolean
  • TIMESTAMP, DATE, DATETIME → Date
  • JSON, JSONB → Record<string, unknown>
  • BYTEA, BLOB → Buffer
  • TEXT[] → string[]

Related Tools

Format SQL queries with the SQL Formatter. Convert SQL to MongoDB with SQL to NoSQL. Generate TypeScript from JSON with JSON to TypeScript. Generate TypeScript from OpenAPI specs with OpenAPI to TypeScript. Generate JSON schemas with the JSON Schema Generator.

Frequently Asked Questions

What SQL dialects are supported?
This tool parses standard CREATE TABLE statements compatible with PostgreSQL, MySQL, SQLite, and SQL Server. It handles column types, NOT NULL constraints, and DEFAULT values.
How are SQL types mapped to TypeScript?
INT/SERIAL → number, VARCHAR/TEXT → string, BOOLEAN → boolean, TIMESTAMP/DATE → Date, JSONB → Record<string, unknown>, BYTEA/BLOB → Buffer, UUID → string, and arrays like TEXT[] → string[].
How are nullable columns handled?
By default, nullable columns get "| null" added to their type. You can toggle "Optional for nullable fields" to use "?" instead, which is better for insert types where you want to omit nullable fields.
Is my data safe?
Yes. All SQL parsing and TypeScript generation happens entirely in your browser. No data is sent to any server.

Related Tools

JSON-YAML Converter

Convert between JSON and YAML formats instantly.

Epoch / Unix Timestamp Converter

Convert Unix timestamps to dates and vice versa.

Markdown to HTML Preview

Convert Markdown to HTML in real time with a live preview.

Curl to Fetch/Axios Converter

Convert curl commands to JavaScript fetch, Axios, or Node.js code instantly.

Tailwind CSS Converter

Convert Tailwind CSS utility classes to plain CSS and vice versa. Supports spacing, colors, typography, flexbox, grid, and more.

Use this tool from AI agents. The CodeTidy MCP Server lets Claude, Cursor, and other AI agents use this tool and 46 others directly. One command: npx @codetidy/mcp

Drop file to load