AI-powered database client and MCP server for desktop and web, supporting Postgres, MySQL, MariaDB, SQL Server, ClickHouse and SQLite.
- Stars
- 5,294
- Forks
- 396
- Open issues
- 126
- Last commit
- 6 hours ago
What is it?
Tabularis is a desktop SQL client built with Tauri, React and Rust. It ships with native drivers for PostgreSQL, MySQL/MariaDB and SQLite, and other databases such as DuckDB, ClickHouse, SQL Server, Redis and Firestore are added through a plugin system. Plugins are standalone executables that talk to the app over JSON-RPC via stdin/stdout, so they can be written in any language and installed from within Settings.
The app covers the usual workflow: a schema tree with inline editing, an interactive ER diagram, a Monaco-based SQL editor with multi-statement execution, a data grid with batch editing and CSV or JSON export, and a visual query builder. It also includes SQL notebooks that mix SQL and Markdown cells, and a Visual EXPLAIN view that renders execution plans as node graphs.
Tabularis includes an MCP server started with `tabularis --mcp`, which lets Claude Desktop, Cursor and Windsurf read schemas and run queries. Optional AI text-to-SQL works with OpenAI, Anthropic, Ollama and other OpenAI-compatible providers.
Key features
- 01Native drivers for PostgreSQL, MySQL/MariaDB and SQLite, plus 24 plugin drivers including DuckDB, ClickHouse and SQL Server.
- 02SQL notebooks combining SQL and Markdown cells with cross-cell variables and charts.
- 03Visual EXPLAIN renders execution plans as interactive node graphs.
- 04Built-in MCP server exposes schema browsing and query execution to AI agents.
- 05Language-agnostic plugin system using JSON-RPC over stdin/stdout.
- 06SSH tunneling and optional system keychain storage for saved passwords.
Use cases
- Querying and editing production or development databases from one desktop app.
- Letting an AI coding assistant inspect a schema and draft queries through MCP.
- Writing reproducible analysis notebooks that combine SQL queries with written notes.
- Working across several database engines without installing a separate client for each.
Quick start
- 1
Install on Windows with WinGet
winget install Debba.Tabularis - 2
Install on macOS with Homebrew
brew install --cask tabularis - 3
Install on Linux with Snap
sudo snap install tabularis
Things to know
- Only PostgreSQL, MySQL/MariaDB and SQLite are built in; other databases need plugins.
- The built-in PostgreSQL driver is deprecated in favour of a separate plugin.
In collections
Topics
FAQ
- What is tabularis?
- Open-source desktop SQL workspace for PostgreSQL, MySQL, SQLite and plugin-based databases, with a built-in MCP server for AI agents. Tabularis is a desktop SQL client built with Tauri, React and Rust. It ships with native drivers for PostgreSQL, MySQL/MariaDB and SQLite, and other databases such as DuckDB, ClickHouse, SQL Server, Redis and Firestore are added through a plugin system. Plugins are standalone executables that talk to the app over JSON-RPC via stdin/stdout, so they can be written in any language and installed from within Settings.
- Is tabularis free to use? What license does it have?
- tabularis is open source under the Apache-2.0 license. Check the license terms before using it in commercial products.
- Is tabularis still maintained?
- Actively maintained. The last commit to tabularis was on Oct 26, 2026.
- What can I use tabularis for?
- Querying and editing production or development databases from one desktop app. Letting an AI coding assistant inspect a schema and draft queries through MCP. Writing reproducible analysis notebooks that combine SQL queries with written notes. Working across several database engines without installing a separate client for each.
- How do I install tabularis?
- Install on Windows with WinGet: winget install Debba.Tabularis Install on macOS with Homebrew: brew install --cask tabularis Install on Linux with Snap: sudo snap install tabularis
- Where can I get tabularis?
- The source code and installation instructions are on GitHub: https://github.com/TabularisDB/tabularis
Summary generated by AI from the project's README. GitHub stats refresh daily.
Related projects
Lightweight cross-platform database client for 100+ databases, with desktop, Docker, CLI, a built-in AI SQL assistant and an MCP server.
A free, open source native database client for macOS and iOS supporting SQL and NoSQL databases, with built-in AI chat and an MCP server.
Cross-platform database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and many other SQL and NoSQL databases, available as desktop app or web app.
A keyboard-driven terminal UI for connecting to and querying many SQL databases, inspired by lazygit.
AI-powered cross-platform desktop SQL client built with Flutter, supporting MySQL, PostgreSQL, SQL Server, SQLite and more.