Early accessMeet the AI agent for your database

Your database.Now with a business mind.

Spectre is a desktop database studio with an AI agent that understands your schema, investigates your data across tables and answers with evidence — while your credentials never leave your machine.

See how it works

PostgreSQL · MySQL · MariaDB · SQL Server macOS Windows

Spectre Studio

Spectre AIAgentAnalystanalytics_prod · Connected

@ordersWhy did revenue drop in August compared to July?

Worked for 14 s · 4 queries

Understood the question: revenue, August vs July
Found 4 relevant tables
Compared revenue by region and category
Every part of the question is covered by evidence

Read query38 ms · 4 rows

SELECT r.name AS region,
       SUM(o.total) FILTER (WHERE o.created_at <  '2026-08-01') AS jul,
       SUM(o.total) FILTER (WHERE o.created_at >= '2026-08-01') AS aug
FROM orders o
JOIN customers c ON c.id = o.customer_id
JOIN regions r ON r.id = c.region_id
WHERE o.status = 'paid'
GROUP BY r.name;

Revenue fell 12.4% — driven by the North region

Order volume stayed almost flat (−3.1%). The drop comes from the average ticket in the North, down 21% after the electronics promotion ended on August 3.

Create dashboardExport PDFOpen in editor

Works with the databases you already run

PostgreSQL
MySQL
MariaDB
SQL Server
macOS
Windows

The agent

It investigates like an analyst. It shows its work like an engineer.

Ask in plain language. Spectre plans the investigation, runs the queries it needs and checks that every part of your question is backed by evidence — only then does it answer.

AI workspace

Load schema48 tables · 612 columns
Search indexReady
Semantic modelReady

Recalled from business memory

Sales → orders.total (paid)Region → customers.region_id

Modes

You decide how much the agent can do.

Switch modes at any time. Changes are previewed, and destructive statements always ask first.

Runs SQL

Agent

Queries data, runs SQL and applies the changes you ask for — with a preview of the affected rows.

Never runs

Query

Explains, reviews and suggests SQL without executing anything on your database.

Approval first

Plan

Investigates, then shows the plan with risk levels. Nothing executes until you approve it.

Proposal only

Design

Shapes tables, keys and indexes and proposes the DDL. Nothing runs.

Response style

One question. The answer your role needs.

Pick how Spectre answers: a business brief for decisions, or a technical briefing with the SQL as evidence.

Spectre AIAnalyst

Top customers are buying less often

Repeat rate

38%

−6 pts

Days between orders

41

+9

Insight. 62 of your top 200 customers have not ordered in 60+ days.

Recommendation. Launch a win-back campaign for this segment this week.

Business memory

Your business has its own language. Spectre learns it.

Teach Spectre what your terms mean once. It remembers confirmed definitions, reads your business rules and applies them to every answer.

Confirmed definitions — and candidates you can review
A business rules document with ## sections and @table references
Reference any table or column with @ while you chat

Business memory

You saySpectre reads

Salesorders.total · status = 'paid'Confirmed
Active customerlast order < 90 daysConfirmed
Pendingstatus = 'processing'Candidate

Business rules

## Revenue

Only count @orders with status paid.

Refunds are stored in @payments.refunded_at.

## Customers

A customer is active if they ordered in the last 90 days.

Product tour

See it work on a real database.

Ask a question, watch the investigation and get the answer with its evidence.

One studio

A complete database studio, with AI in every step.

Not just a chat. Spectre is the desktop client you use every day — editor, grid, designers, dashboards and operations.

AI SQL editor

Schema-aware autocomplete and an assistant inside the editor: explain, fix, optimize or review any query in place.

1SELECT date_trunc('day', created_at) AS day,
2       COUNT(*) AS orders, SUM(total) AS revenue
3FROM orders
4WHERE created_at >= '2026-06-01'
5GROUP BY 1 ORDER BY 1;

Optimize

Add an index on orders(created_at) — this query scans 1.2M rows.

AI dashboards

Describe the dashboard you want. Spectre checks the data exists and builds widgets, filters and parameters. Export to PowerPoint.

Sales overview

Revenue

$412.8K

Orders

9,184

Executive briefs

Turn any investigation into an executive summary with charts, ready to share as PDF.

Schema control

Snapshots, diffs, drift detection and generated migration SQL for every connection.

Visual designers

Design tables, constraints, indexes, views and routines without hand-writing DDL.

Editable data grid

Fast, virtualized grid with filters and inline edits. Every change is previewed as SQL before it runs.

Database operations

Live sessions, locks, storage and engine metrics — plus users, roles and grants.

SQL library & import/export

Save queries in folders, run SQL scripts, import CSV and export to CSV, JSON or SQL.

Local-first & safe

Your data stays yours. The agent stays in its lane.

Spectre connects straight from your machine to your database. No proxy, no credential cloud — and clear guardrails on what the agent can run.

Local-first

Your machine

App · keychain

Direct

Your database

PostgreSQL · MySQL · SQL Server

Spectre AI

Question · schema · capped previews

Credentials in your OS keychain
Passwords never reach our servers or the AI.
Direct connection
Nothing proxies between you and your database.
Only what the answer needs
The AI sees your question, schema metadata and small, capped result previews — never a copy of your database.
Cloud is optional
Use local mode without an account, or sync workspaces with your team when you choose.

Guardrails

Plan mode: nothing executes until you approve
Destructive statements always ask for confirmation
Preview of affected rows before any change
Risk level on every proposed change
You control whether the agent may run read queries
Query timeouts and sanitized errors

FAQ

Questions, answered.

hello@spectredbstudio.com

What is Spectre Studio?

A desktop database client for macOS and Windows with an AI agent built in. You can write SQL, edit data and design schemas like in any studio — or ask questions in plain language and let the agent investigate.

Which databases are supported?

PostgreSQL, MySQL, MariaDB and SQL Server, over local or remote connections with SSL.

Does my data leave my machine?

Connections go directly from the app to your database, and passwords stay in your OS keychain. When you use the AI, it receives your question, schema metadata and small, capped result previews — never a copy of your database.

Can the agent change my data?

Only if you let it. Query and Design modes never execute anything, Plan mode waits for your approval, and destructive statements always ask for confirmation with a preview of the affected rows.

Do I need to know SQL?

No. Analysts can ask in plain language and get business briefs. Developers get the full SQL as evidence, and can open it in the editor at any time.

How does early access work?

Join the list with your email. We’ll let you know as soon as Spectre Studio is ready for you to download.

Your data already has the answers.

Spectre Studio is in early access. Leave your email and we’ll let you know as soon as it’s ready for you.

PostgreSQL · MySQL · MariaDB · SQL Server · macOS · Windows