SQL to PocketBase Converter

A lightweight, premium-designed web tool to instantly convert PostgreSQL schema definitions (CREATE TABLE) into PocketBase JSON collections.

🚀 Features

• Instant Conversion: Parses SQL commands purely in the browser (client-side).
• Smart Type Mapping:
  • VARCHAR/TEXT → text
  • INT/SERIAL → number (onlyInt: true)
  • BOOLEAN → bool
  • JSONB → json
  • TIMESTAMP → date (or autodate for system fields)
• Relation Detection: Automatically detects Foreign Keys (user_id → relation to user_collection).
• Premium UI: Modern dark mode aesthetic, glassmorphism, and responsive design.
• Export Options: Copy directly to clipboard or download as .json.

🛠️ Usage

1. Enter SQL: Paste your CREATE TABLE statements into the left panel.
2. Convert: Click the "Convert Schema" button.
3. Import: Download the JSON and import it directly into your PocketBase dashboard ("Settings" > "Import collections").

Example Input

CREATE TABLE posts (
    id UUID PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    content TEXT,
    is_published BOOLEAN DEFAULT false,
    author_id UUID, -- Auto-detected as relation to 'author_collection'
    created_at TIMESTAMP DEFAULT NOW()
);

💻 Tech Stack

• HTML5
• Vanilla CSS3 (Custom variables, Flexbox/Grid, Animations)
• Vanilla JavaScript (ES6+, Regex parsing)
• Zero Dependencies

📄 License

MIT License. Feel free to use and modify for your own projects.