OpenTable 1.1.2

Recommended for anyone on 1.1.0 or 1.1.1 — this fixes data loss when
editing table structure.

Fixed: schema edits could lose data

Altering a table could silently damage it. On SQLite, a rebuild dropped indexes
and truncated composite foreign keys to their last column, leaving the table
unusable. On PostgreSQL, column types were read back without their parameters
and referential actions were lost entirely.

Editing a table used to…	Now
drop unique and partial indexes on SQLite	preserved across the rebuild
turn a composite FK (a,b) into (b)	preserved, in order
read varchar(255) back as varchar	length kept
read numeric(12,2) back as numeric	precision kept
reset ON DELETE / ON UPDATE to no action	preserved

If you have edited a table's structure in 1.1.0 or 1.1.1, it is worth checking
that its indexes and foreign keys are still what you expect.

Fixed: connections dropping

An idle session dropped by a server, NAT or load balancer left the app stuck on
"Not connected" until you restarted it. Keepalive is now enabled, a heartbeat
detects a dead socket early, and the next query reconnects on its own. The
status bar shows whether you are connected, reconnecting, or dropped.

Faster structure inspection

Opening Structure on a large table no longer runs an exact COUNT(*). Row
counts come from catalog estimates and are marked approximate, so inspecting a
hundred-million-row table costs metadata rather than a full scan.

Safer AI auto-run

The rules deciding what the assistant may run unattended now use a real SQL
scanner rather than pattern matching — it understands dollar-quoted bodies,
nested comments and nesting depth. Sequence mutation (nextval, setval) and
advisory locks now require approval, and there is a regression suite so these
cases stay fixed.

Thanks to @HostX0 for both fixes.

Download

Your machine	File
Mac, Apple Silicon	OpenTable-1.1.2-arm64.dmg
Mac, Intel	OpenTable-1.1.2-x64.dmg
Windows	OpenTable-Setup-1.1.2.exe
Linux	OpenTable-1.1.2.AppImage or opentable_1.1.2_amd64.deb

macOS builds are signed and notarised. Existing installs update themselves.

OpenTable 1.1.1

Chat with your database, run AI models locally, and stay connected.

Chat

A conversation panel that answers from your actual data, not just your schema.
Ask "how many orders failed last month?" and get the number — it writes the
query, runs it, and reads the result back.

• Read-only SELECTs run immediately
• Anything that writes stops and asks you first, showing the exact SQL
• Every query it ran stays visible, so the whole chain is auditable
• Answers stream in as they are written
• Conversations are saved per database, with a resizable panel and full-screen mode

What it may run unattended is an allowlist, not a blocklist, because the SQL is
model-generated. Statements that merely look like reads — a WITH clause
hiding a DELETE, SELECT … INTO, INTO OUTFILE, FOR UPDATE — all require
your approval.

Bring your own model

The AI provider is now configurable. Alongside Anthropic, OpenTable speaks to
any OpenAI-compatible endpoint:

Local	Remote
Ollama, LM Studio	vLLM, OpenRouter, Groq, NVIDIA NIM

Point it at http://localhost:11434 in Settings and your schema never leaves
your machine — which matters, because the prompt includes your table and
column names.

Fixes

• Connections no longer die silently. An idle session dropped by a server,
  NAT or load balancer used to leave the app stuck on "Not connected" until you
  restarted it. Keepalive is now enabled, a heartbeat detects a dead socket
  early, and the next query reconnects on its own. The status bar shows whether
  you are connected, reconnecting, or dropped.
• Chats stay with their database. A conversation grounded in one schema
  could previously be reopened beside a different database. Chats are now scoped
  to the connection and database they belong to.
• Assistant replies render as formatted text rather than raw markdown
• Permission prompts show highlighted SQL and say what will happen in plain
  English, with irreversible statements marked distinctly
• Fixed unclickable window controls in full-screen chat on macOS

Download

Your machine	File
Mac, Apple Silicon	OpenTable-1.1.1-arm64.dmg
Mac, Intel	OpenTable-1.1.1-x64.dmg
Windows	OpenTable-Setup-1.1.1.exe
Linux	OpenTable-1.1.1.AppImage or opentable_1.1.1_amd64.deb

macOS builds are signed and notarised. Existing installs update themselves.

OpenTable 1.1.0

Chat with your database, and run AI models locally.

Chat

A conversation panel that answers from your actual data, not just your schema.
Ask "how many orders failed last month?" and get the number — it writes the
query, runs it, and reads the result back.

• Read-only SELECTs run immediately
• Anything that writes stops and asks you first, showing the exact SQL
• Every query it ran stays visible, so the whole chain is auditable
• Answers stream in as they are written
• Conversations are saved and searchable; resizable panel and a full-screen mode

What it may run unattended is an allowlist, not a blocklist, because the SQL is
model-generated. Statements that merely look like reads — a WITH clause
hiding a DELETE, SELECT … INTO, INTO OUTFILE, FOR UPDATE — all require
your approval.

Bring your own model

The AI provider is now configurable. Alongside Anthropic, OpenTable speaks to
any OpenAI-compatible endpoint:

Local	Remote
Ollama, LM Studio	vLLM, OpenRouter, Groq, NVIDIA NIM

Point it at http://localhost:11434 in Settings and your schema never leaves
your machine — which matters, because the prompt includes your table and
column names.

Also

• Assistant replies render as formatted text rather than raw markdown
• Permission prompts show highlighted SQL and say what will happen in plain
  English, with irreversible statements marked distinctly
• Fixed unclickable window controls in full-screen chat on macOS

Download

Your machine	File
Mac, Apple Silicon	OpenTable-1.1.0-arm64.dmg
Mac, Intel	OpenTable-1.1.0-x64.dmg
Windows	OpenTable-Setup-1.1.0.exe
Linux	OpenTable-1.1.0.AppImage or opentable_1.1.0_amd64.deb

macOS builds are signed and notarised. Existing installs update themselves.

OpenTable 1.0.0

The first release of OpenTable — a clean, fast SQL editor for the desktop.
PostgreSQL, MySQL/MariaDB and SQLite, locally or through an SSH tunnel.

Which file do I want?

Your machine	Download
Mac, Apple Silicon (M1–M4)	OpenTable-1.0.0-arm64.dmg
Mac, Intel	OpenTable-1.0.0-x64.dmg
Windows	OpenTable-Setup-1.0.0.exe
Linux	OpenTable-1.0.0.AppImage or opentable_1.0.0_amd64.deb

The macOS builds are signed and notarised by Apple, so they open without
warnings. Updates install themselves from here on.

What's in it

Connect — PostgreSQL, MySQL/MariaDB and SQLite. SSH tunnels through
ssh-agent, a private key or a password, with your ~/.ssh/config hosts
offered in a dropdown. Paste a postgres:// or mysql:// URL and the form
fills itself. Passwords are stored in the OS keychain, never in plain text.

Query — schema-aware autocomplete from your actual tables and columns.
Run the selection or just the statement under the cursor with ⌘⏎. Cancel a
running query, so a runaway SELECT never locks up the connection. Query
history, saved queries, and a ⌘K palette over all of it.

Read — a virtualised grid that stays smooth on large results, with
sorting, filtering, and export to CSV, JSON, SQL or Markdown.

Edit — double-click a cell to change it. Every edit applies in one
transaction using bound parameters, and only when the result maps cleanly to
a single table with a primary key.

Design — build tables visually with live SQL, and alter existing ones:
add, rename, retype and drop columns, change the primary key, manage indexes
and foreign keys. Every change is shown as exact SQL before it runs.

AI (optional, bring your own Anthropic key) — ask in plain English,
explain a query, or fix one that errored, grounded in your real schema.

Safety — confirmation before an UPDATE or DELETE with no WHERE,
and before any write on a connection you have marked as production.

Notes

Linux builds are x86-64. SQLite needs no server — just open a file.

Found a problem? https://github.com/mohammedkmo/OpenTable/issues