Ask
The number, the chart, and the queries behind it.
Database editor with AI/macOS and Windows
Your database,
now answers.
A database editor like DataGrip, with AI built in. Write, fix and optimize SQL, or ask in plain language and get answers from an expert in your business.
Spectre AI
Good afternoon
on store
PostgreSQL, MySQL, and MariaDB.
- PostgreSQL
- MySQL
- MariaDB
Agent
Answers from your schema.
Investigates and shows the SQL.
SQL
Fix and optimize SQL with AI.
It proposes the change. You review it before anything runs.
Memory
It keeps your definitions.
Business memory
What “net sales” includes.
Semantic model
It already knows the tables.
@ mention
Point at a table or column.
PDF brief
The thread, ready to share.
Product
Where the work happens.
Edit
The statement already open in the editor.
Keep
Metrics stay live on a dashboard.
Share
Share the report, not the database.
A link to a frozen snapshot.
- Report
- Dashboard
- Password
- The link expires
Assistants
Ask Claude or Cursor about your database.
Spectre is an MCP server on your computer. Your assistant gets the schema, your business notes, and read-only queries. The data stays on your machine.
- 1
Open Spectre
Connect your database as usual.
- 2
Turn on Assistants
Settings → Assistants (MCP). Pick the connections to share.
- 3
Add your assistant
One click for Claude Desktop and Cursor. One copied command for Claude Code.
Claude DesktopCursorClaude Code
Then just ask
- “What tables do I have and how do they relate?”
- “How many orders did we have last month, by country?”
- “Which customers have not bought in 90 days?”
What the assistant gets
The schema
Tables, columns, keys and relations.
Your notes
What "active customer" or "sale" means in your business.
Read-only SQL
It can query. It can never write.
Listens only on 127.0.0.1 behind a secret. Passwords stay in the keychain, personal data can stay masked, and if Spectre is closed your assistant opens it.
Security
The database stays put.
Keychain
Passwords never leave the OS.
Direct
The app opens the connection.
SSH
When the database sits behind a bastion.
Masked
Emails and phones stay off the model.
Writes wait
Nothing destructive runs on its own.
No account
The studio works locally.
Pricing
Free to start. Pro when you need more AI.
Free and Pro are for one person. Enterprise is for a team: one price, one AI budget the whole team shares.
Free
One person — share workspaces.
$0
AI usage included every month
- MySQL & PostgreSQL — workspaces, projects, connections
- SQL editor, data grid, and visual table designer
- Schema versioning — snapshots, drift, and migration SQL
- SQL library, KPI dashboards, and shared workspaces
- Spectre AI with reasonable monthly usage
- Local mode without an account
Pro
One person — much more AI for daily work.
$19/mo
10× more AI than Free
- Everything in Free
- Spectre AI with generous monthly usage
- Share individual workspaces — passwords stay local
- Upgrade or cancel anytime from your account
Enterprise
Your team — one AI budget shared by every member.
$29/mo
18× more AI than Free, shared by your team
- Everything in Pro, for your whole team
- One AI budget shared by every member
- Shared workspaces with role-based access
- One flat price for the team, not per seat
- Organization name on your account
Sign in
Pro and Enterprise can buy extra AI anytime. Move up or cancel whenever you want.
Questions, answered.
hello@spectredbstudio.comWhat 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 and MariaDB. Local or remote, with SSL, and through an SSH tunnel when the database is only reachable from a bastion.
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.
Can Cursor or Claude use the database?
Yes, if you turn on Assistants (MCP). They can see the schema, your business memory, and run read-only queries on the connections you share. The server listens only on your machine. Passwords stay in the keychain, and personal data can stay masked.
Is Spectre in beta?
Yes. Spectre is a public beta for macOS (Apple Silicon) and Windows. Download it, create a free account, and tell us what breaks or what is missing at hello@spectredbstudio.com.
Download the Spectre beta
Free to start. Create your account the first time you open it.
Beta build: if macOS says it can’t verify the app, open System Settings → Privacy & Security and choose “Open Anyway”.
PostgreSQL · MySQL · MariaDB · macOS · Windows
Contact