Studio

Neutron Studio is a web-based database manager that connects to Nucleus and PostgreSQL. Browse schemas, run queries, design tables, and explore all 14 data models — all from your browser.

Launch

neutron studio               # opens http://localhost:4983
neutron studio --port 8080   # custom port

Studio is embedded in the CLI binary — no Node.js runtime needed.

Features

Connection Manager

  • Save multiple database connections
  • Test connections before saving
  • Auto-detect Nucleus vs PostgreSQL
  • When connected to Nucleus, all 14 model browsers are enabled

SQL Browser

Browse table data with pagination, column details, and index information.

SQL Editor

Full-featured SQL IDE with:

  • CodeMirror with SQL syntax highlighting
  • Execute with Cmd/Ctrl+Enter
  • Query History — Last 50 queries per connection (localStorage), with timestamp, row count, and duration
  • Saved Queries — Persist named queries to the database
  • Results — Table view with CSV and JSON export

Schema Designer

Visual table editor:

  • Create tables — Add columns with type picker, nullable, primary key, defaults
  • Edit columns — Modify existing tables
  • Manage indexes — Create/drop regular and unique indexes
  • Code generation — Generate model boilerplate in Go, TypeScript, Rust, or Python
  • Migration export — Download pending changes as timestamped .sql files
  • Drop table with confirmation

Model Browsers

When connected to Nucleus, Studio provides dedicated browsers for all 14 data models:

| Model | Browser Features | |-------|-----------------| | SQL | Table data viewer with pagination | | Key-Value | Key browser with TTL, value editor | | Vector | Embedding viewer, similarity search | | TimeSeries | Time range queries, chart preview | | Document | JSON editor, GIN index queries | | Graph | Node/edge browser, Cypher queries | | FTS | Search playground, BM25 scoring | | Geo | Map preview, radius queries | | Blob | Content list, metadata, download | | PubSub | Channel monitor, test publisher | | Streams | Consumer group viewer, playback | | Columnar | Column projections, aggregation preview | | Datalog | Rule browser, query evaluator | | CDC | Change log viewer |

Architecture

  • Frontend: Preact + @preact/signals SPA
  • Backend: Go server embedded in CLI binary (//go:embed)
  • Editor: CodeMirror with One Dark theme
  • Data grid: TanStack React Table
  • State: Preact signals (connections, schema, tabs, toasts)
  • Dev loop: cd studio && npm run dev (Vite proxies API to Go server)