Titanbase
Roadmap

Local-first, built in the open.

A direction, not a fixed schedule. Priorities shift with contributor feedback, real-world usage, and implementation constraints.

ROADMAP.md
Overall progress86%
91%
Phase 1
83%
Phase 2
83%
Phase 3

Product principles

The constraints that keep Titanbase honest.

Local-first by default.

.titan.json remains the portable source of truth.

The visual editor and generated code represent the same schema.

Core schema tooling stays open source and usable without an account.

Editor, desktop app, CLI, format, and exporters stay useful without Cloud.

Cloud, collaboration, auth, billing, and AI are never required for the local product.

Now

Current focus

Harden the local editor and desktop workflow before expanding into CLI, automation, or cloud workflows.

  • Finish and harden the local web editor before expanding scope.
  • Harden the local editor UX and validation.
  • Add Mermaid, Prisma, and Drizzle exporters with focused tests.
  • Document the .titan.json format.
  • Add the first local PostgreSQL SQL import foundation.
  • Add schema diff foundations.
  • Package the proven local workflow as a desktop application.
  • Add CLI and automation workflows after the public APIs stabilize.
The plan

Phases

Each phase builds on a stable foundation from the last.

  1. 1
    Phase 1In progress

    Local Web Editor MVP

    The core loop: model, edit, validate, and export — entirely in the browser.

    39/43 done91%

    Core Schema

    • TypeScript TitanSchema model.
    • Zod schema validation.
    • Schema normalization.
    • Project, table, column, relation, index, and enum models.
    • Editor metadata and persisted table positions.
    • Valid empty-schema factory.
    • Basic diagnostics.
    • Example schemas and validation tests.

    Editor Foundations

    • React visual schema editor.
    • React Flow canvas derived from TitanSchema.
    • Blank schema flow and template picker.
    • Open, save, and load .titan.json files.
    • Browser autosave and dirty-state tracking.
    • Safe navigation for unsaved schemas.
    • Undo/redo history and keyboard shortcuts.
    • Search, auto-layout, and fit view.

    Schema Editing

    • Add, edit, and delete tables and columns.
    • Edit type, default, description, nullability, PK, and uniqueness.
    • Create, edit, and delete relations with cardinality and actions.
    • Indexes: methods, partial clauses, and multi-column.
    • Create enums and reference them from column types.

    Canvas & Inspector UX

    • Project overview and context-aware inspectors.
    • Collapsible, pinnable, hover-preview inspector.
    • Compact table cards with PK/FK/UQ/IDX/NN badges.
    • Foreign-key highlighting and explicit relation labels.
    • Light, dark, and system themes across the canvas.
    • Balanced, responsive start screen with call-to-action cards.
    • Touch-friendly canvas panning and zoom on mobile.

    Validation & Export

    • Grouped validation panel with object selection.
    • Titan JSON and PostgreSQL export preview, copy, download.
    • Supabase and Neon PostgreSQL export presets.
    • PG relations, enums, indexes, defaults, comments, constraints.
    • Advanced relation and dialect-specific diagnostics.
    • Detect unsafe or contradictory constraints.
    • Export Mermaid ERD, Prisma, and Drizzle.

    MVP Hardening

    • Unit tests for mutations, undo/redo, and statistics.
    • PostgreSQL exporter and settings persistence tests.
    • Mermaid, Prisma, and Drizzle exporter tests across examples.
    • Exporter edge-case coverage for identifiers, warnings, and defaults.
    • Component and automated browser tests for key flows.
    • Accessibility pass for keyboard and focus management.
    • Large-schema performance benchmarks.
    • Cross-version Titan format compatibility tests.
  2. 2
    Phase 2In progress

    Exporters, Import & Schema as Code

    Bring existing schemas in, send them out to more targets, and diff changes.

    19/23 done83%

    Additional Exporters

    • Mermaid ER diagrams.
    • Prisma schema files.
    • Drizzle PostgreSQL schema files.
    • Supabase and Neon PostgreSQL export presets.
    • DBML export.
    • Deterministic fixtures and warning coverage.
    • Exporter tests across template schemas.

    Import

    • Import PostgreSQL from a .sql file.
    • Convert imported SQL into normalized TitanSchema.
    • Surface unsupported statements and import warnings.
    • Drag and drop .titan.json and .sql in the editor.
    • Preserve comments, defaults, indexes, enums, actions.

    Diff & Migration Foundations

    • Structural schema diff engine.
    • Visual added / removed / changed states.
    • Compare two .titan.json files.
    • PostgreSQL migration draft preview with destructive-change warnings.
    • Stable object matching and conservative rename detection.
    • Export migration draft as PostgreSQL SQL.
    • Onboarding SQL samples for PostgreSQL, Supabase-style, and Neon workflows.

    Schema Format

    • Publish the .titan.json format specification.
    • Publish a versioned JSON Schema.
    • Document normalization, serialization, and compatibility.
    • Import/export round-trip fixtures.
  3. 3
    Phase 3In progress

    Desktop App

    Free, open source, account-free — the local workflow as a native Electron app.

    10/12 done83%

    Foundations

    • Free and open source, no account or cloud backend.
    • Electron shell with the bundled local editor renderer.
    • Open, save, and Save As .titan.json from the filesystem.
    • Local PostgreSQL .sql import.
    • Recent files and drag-and-drop.

    Native Experience

    • Native menus, shortcuts, and OS file-open events.
    • Native export, compare, and migration-draft actions.
    • Unsaved-change prompts and offline-first workflow.
    • File-change detection and reload prompts.
    • Electron Builder targets for macOS, Windows, and Linux.
    • Signed, notarized installers and auto-update.
    • Crash-safe local drafts.
Future

Titanbase Cloud

A possible future layer for teams. The local editor, format, exporters, desktop app, and CLI must stay fully useful without an account.

Collaboration

  • Cloud projects and team workspaces.
  • Realtime collaboration and comments.
  • Version history and review workflows.
  • Shareable read-only links and PR comments.

Database Workflows

  • Live database import and drift detection.
  • Saved connections and environment comparison.
  • Advanced migration review and approval.

Organization & Security

  • Authentication and account management.
  • Billing, SSO, roles, and permissions.
  • Audit log and data retention controls.

Optional AI

  • AI schema review and generated documentation.
  • Natural-language schema exploration.
  • Migration risk explanations.