Coming soon

Spectre Studio

The AI workspace for your database.

macOS · Windows · Linux — join the list for early access See the product

Thought0s

Spectre Studio·Northline

ordersProductionRun

id	customer	total	status
1042	Ada Lovelace	$248	paid
1041	Grace Hopper	$89	shipped
1040	Alan Turing	$412	pending

3 of 12,480LIMIT 100

Northline

Team sync flow

Live

Ada

Owner

Grace

Admin

Alan

Member

Workspace

Sync hub

Projects

Shared

SQL Library

Shared

Credentials

Local only

joinsyncstays local

Invite your team. Keep keys local.

Shared projects and SQL — passwords never leave each machine.

Get early access

Ask & measure

Copilot and live KPIs.

Ask in plain language or prompt a dashboard — both stay schema-aware and on your machine.

Copilot

Schema-aware Copilot that writes real SQL.

Reference tables with @, optimize joins, explain plans, and validate queries against your live schema.

Spectre Studio·Copilot

Copilot

Schema-aware · 42 tables

ExplainOptimizeJoinReview

Optimize this SELECT on @orders — skip the table scan.

Copilot · index-aware

Use orders.status and the FK to customers.

SELECT c.name, SUM(o.total) AS revenue
FROM orders o
JOIN customers c ON c.id = o.customer_id
WHERE o.status = 'paid'
LIMIT 20;

Type @ to reference tables or FKs

Agent gemini-flash

Dashboards

Prompt a KPI board. Spectre binds the data.

Describe MRR, churn, or AOV. The agent writes the queries, wires the widgets, and keeps them live.

Spectre Studio·Dashboards

Revenue health

AI · Production

MRR

$84.2k

+12.4% MoM

Customers

3,184

+6.1% MoM

Churn

2.4%

−0.3% MoM

AOV

$126

+4.8% MoM

Prompt a dashboard — queries bind to widgets

Monthly KPI board from @orders and @subscriptions

Agent gemini-flash

Design & connect

Design mode and your workspace.

Draft schema in chat, then browse connections and tools without leaving the desktop app.

Design mode

Design tables in chat. Preview before apply.

Draft columns, PKs, and FKs in Design mode. Review the layout and SQL — nothing runs until you say so.

Spectre Studio·Design mode

AI Assistant

Design

Design a shipments table with FK to @orders

shipments

Preview · not applied

iduuidPK
order_iduuidFK
carriervarchar(64)
trackingvarchar(128)
shipped_attimestamptz

Describe the table or change…

Design gemini-flash

Workspace

Connections, schema, and tools in one view.

Browse MySQL and PostgreSQL side by side. Check health, expand schemas, and jump into SQL.

Spectre Studio·Workspace

Production

Healthy · PostgreSQL 16.2

AI Assistant

e.g. list tables, write a SELECT…

New SQL query⌘⇧N

SQL Library⌘⇧O

Ship & reuse

Schema control and SQL library.

Catch drift before it ships, and keep the queries you trust one shortcut away.

Schema control

Track drift before it ships.

Snapshot schemas, spot drift, and preview publish SQL — without touching the data.

Spectre Studio·Schema control

commerce · Production

In sync

SnapshotDrift check

v24 · add shipments.carrier2h ago
v23 · index orders.statusYesterday
v22 · payments.method enum3 days ago

-- Publish preview (not executed)
ALTER TABLE shipments
  ADD COLUMN carrier VARCHAR(64);

SQL Library

Save once. Reuse forever.

Organize queries in folders, pin daily ones, and open them with a shortcut from any connection.

Spectre Studio·SQL Library

Search saved queries…

Revenue

Top customers MTD
MRR by plan

Ops

Failed payments 7d
Open shipments

SELECT c.name, SUM(o.total) AS revenue
FROM customers c
JOIN orders o ON o.customer_id = c.id
GROUP BY c.name;

Local-first

Your schema, your keys, your machine

Credentials stay on your machine. Connections go straight to your database — no proxy in the middle.

Spectre Studio·Connection · Production

SSL/TLS enabled · local keyring

Hostdb.internal:5432

Databasecommerce

Password•••••••• (OS keyring)

API keysStored locally

Credentials never leave your machine. Spectre connects directly to your database — no cloud proxy.

Get early access to Spectre Studio

We are finishing the desktop app. Leave your email and we will notify you when it ships.