mantichora_

-- beta · The first release is on its way.

Every database you work with, in one window.

Sixteen kinds of database and three message brokers. Write the statement, press one key, and edit what comes back.

The Mantichora window: the object tree of a SQLite database, a console with a query and the grid of its rows

What it does

-- console

A console that knows your schema

Completes table and column names from the open schema, formats a statement, explains its plan, asks for the values of its parameters and keeps a searchable history.

-- grid

A grid that edits in place

Change the rows of a table right in the result and preview the statements first; sort, filter, find, draw bars and export to CSV, JSON, SQL, Markdown, HTML, XML and Excel.

-- structure

Structure from a form

On PostgreSQL, tables, columns, indexes, constraints, sequences and roles are created and changed from forms that show the statement before it runs.

-- tools

Diagrams and comparisons

A diagram of a schema, two schemas or two tables’ rows compared, rows copied between connections, a schema dumped to SQL, a delimited file loaded and a table filled with generated rows.

-- brokers

Brokers beside databases

Kafka topics and NATS streams in the same tree, with a live feed of what arrives; a message taken from a RabbitMQ queue, or only looked at. Nothing is published.

-- safety

Careful with production

A production connection is marked, opens in manual commit and asks before a statement with no WHERE or one that drops; a read-only one sends only reads. Passwords stay in the system’s store.

Two keys to start with

CtrlEnterRunthe statement under the cursor; ⌘ on a Mac
CtrlPEvery commandfound by typing its name

New connection

16 databases · 3 brokers

-- through the same protocols it also knows Amazon Redshift, CockroachDB, CrateDB, YugabyteDB, Materialize, GreptimeDB, openGauss and Greenplum (PostgreSQL), MariaDB, TiDB, OceanBase and Apache Doris (MySQL), and OpenSearch.

The first release is on its way.

-- not signed yet: Windows and macOS ask before the first start, and the download page says what to press.

What is new

The first release is on its way.

All release notes