Getting Started

Create a connection

When Mantidb starts, it opens the welcome window with your saved connections. You can open it again at any time with ⌘N (File ▸ Connections…).

1. Click Create Connection (or + ▸ New Connection…).
2. Pick a Driver — PostgreSQL, MySQL / MariaDB, SQLite, SQL Server, Redis or MongoDB.
3. Fill in Host, Port, User, Password and Database. For SQLite, choose the database file instead.
4. Choose a Tag, such as Development or Production. The tag sets the connection's color and its default safe mode.
5. Click Connect, or Save to keep it for later.

Already have a connection string? Copy it and press ⌘V in the welcome window — Mantidb understands postgres://, mysql://, sqlserver://, redis://, mongodb:// and sqlite:// URLs. See Connections.

Open a table

Each connection opens in its own workspace window. Your tables, views and functions are listed in the sidebar on the left.

• Click a table to open it in a preview tab.
• Double-click it to keep the tab open.
• Press ⌘K to jump to any table by typing part of its name.

The grid shows one page of rows (300 by default). Use the filter bar above the grid to narrow them down, and the Data, Structure and Indexes buttons at the bottom to switch views.

Edit data

Double-click a cell — or select it and press Return — to edit it. Edited cells turn amber until you save them.

• ⌘I adds a row.
• Delete marks the selected rows for deletion.
• ⌘S commits every pending change in a single transaction.

Nothing is written to the database until you commit. Click Preview in the bottom bar to see the exact SQL first.

Run a query

Press ⌘T (or click SQL in the top bar) to open a query tab, type your SQL and press:

• ⌘↩ to run the statement under the cursor (or the selection).
• ⇧⌘↩ to run the whole script.

Every query you run is saved in the History tab of the sidebar, and you can keep the ones you reuse with ⌘D (Save as Favorite…).

Next steps

• Learn the parts of the window in The Interface.
• Protect production with Safe Mode.
• See every shortcut in Shortcut Keys.