MCP Servers · TabularisDB

tabularis

Tabularis is an open-source desktop SQL workspace supporting 15+ databases (PostgreSQL, MySQL, SQLite, DuckDB, ClickHouse, Redis, Firestore, and more) with built-in MCP server integration for AI agents like Claude and Cursor. It features SQL notebooks, visual query builders, and EXPLAIN plan visualization—all free under Apache 2.0.

Talk to DEV.co Discuss Implementation

Source: GitHub — github.com/TabularisDB/tabularis

3.6k

GitHub stars

227

Forks

TypeScript

Primary language

Apache-2.0

License (OSI-approved)

Key facts

Objective fields from the source. Values we can't verify are shown as “Unknown” rather than guessed.

Field	Value
Repository	TabularisDB/tabularis
Owner	TabularisDB
Primary language	TypeScript
License	Apache-2.0 — OSI-approved
Stars	3.6k
Forks	227
Open issues	83
Latest release	v0.14.0 (2026-07-07)
Last updated	2026-07-08
Source	https://github.com/TabularisDB/tabularis

What tabularis is

TypeScript/Rust desktop application (Tauri-based) providing unified SQL interface across heterogeneous database backends via pluggable drivers. Exposes Model Context Protocol (MCP) server enabling AI agents to read schema and execute queries. Includes SQL notebook environment with cross-cell variables and charting, visual query execution plans, and JSON-RPC plugin architecture.

Quickstart

Get the tabularis source

Clone the repository and explore it locally.

terminalbash

1git clone https://github.com/TabularisDB/tabularis.git2cd tabularis3# follow the project's README for install & configuration

Need it deployed, integrated, or customized instead? DEV.co ships production installs.

Best use cases

Multi-database development workflows

Teams juggling PostgreSQL, MySQL, SQLite, and specialized stores (DuckDB, ClickHouse, Redis) benefit from unified UI, eliminating client switching and reducing cognitive load during schema exploration and ad-hoc querying.

AI-augmented database work with local models

Built-in MCP server lets Claude, Cursor, and Devin read your live schema and execute queries without leaving the IDE. Combined with local Ollama support for text-to-SQL, enables privacy-preserving AI-assisted development.

Interactive data exploration and documentation

SQL notebooks mix SQL, Markdown, and visualizations in a single artifact—ideal for exploratory analysis, ad-hoc reporting, and sharing query narratives with non-technical stakeholders.

Implementation considerations

MCP server integration requires explicit IDE configuration (Claude, Cursor, Devin). Verify your target IDE version supports MCP before standardizing across teams.
Plugin system uses JSON-RPC over stdio; custom drivers require implementation of driver interface. Evaluate effort if you need proprietary or in-house database connectors.
Desktop app lifecycle management (auto-updates, binary signing, distribution) differs from web tools; plan rollout for heterogeneous OS environments (Windows/macOS/Linux).
Local Ollama dependency for text-to-SQL feature adds operational complexity; ensure model serving infrastructure is stable or fall back to cloud AI.
SQL notebooks are local files; no built-in version control or collaboration. Integrate with Git workflows manually or use external sync.

When to avoid it — and what to weigh

Need enterprise database driver breadth — Tabularis intentionally focuses on a smaller, well-maintained set of drivers. If you require 100+ RDBMS and data warehouse connectors out of the box, DBeaver CE remains more comprehensive.
Strict air-gapped or regulatory compliance environments — MCP server and AI features (even local Ollama) introduce new surface area. If your environment prohibits any external protocol exposure or dynamic query execution from external agents, risk assessment required.
Require server-mode or web deployment — Tabularis is desktop-only (Windows, macOS, Linux via Snap/Flatpak). No web interface or server mode. Teams needing centralized, browser-accessible SQL workspaces should consider web-native alternatives.
Need mature, battle-tested production database administration — Project launched January 2026 (latest release July 2026). Early-stage relative to DBeaver or TablePlus. Not recommended as sole DBA tool for mission-critical production databases without parallel testing.

License & commercial use

Apache License 2.0. Permissive OSI license allowing modification, distribution, and commercial use under attribution. No copyleft obligations or linking restrictions.

Apache 2.0 explicitly permits commercial use, modification, and redistribution. You may bundle Tabularis in proprietary products, charge for support/services, or use internally in commercial contexts. Retain the license notice and copyright attribution. No patent retaliation clause. Review your derivative work policies if modifying source; no additional restrictions apply.

DEV.co evaluation signals

Editorial assessment — not user reviews. Directional, with an explicit confidence level.

Signal	Assessment
Maintenance	Active
Documentation	Adequate
License clarity	Clear
Deployment complexity	Low
DEV.co fit	Good
Assessment confidence	High

Security considerations

Desktop app with local database credentials stored in configuration. MCP server exposes schema and query execution to connected agents (Claude, Cursor, Devin)—trust boundary is your IDE and AI agent. No public security audit found. Early-stage project; security posture not yet hardened. If handling sensitive credentials or queries, evaluate credential storage encryption, MCP authentication, and network isolation.

Alternatives to consider

DBeaver Community Edition

Broader database support (100+), mature codebase, larger community. Free and Apache 2.0. But no SQL notebooks, no built-in MCP, no Ollama integration. Better for multi-database admins; less ideal for AI-assisted workflows.

TablePlus

Polished UI, strong macOS/iOS experience, cross-platform desktop clients. Commercial (paid). Superior UX for single-database workflows but no notebooks, no AI features, smaller driver set. Not open-source.

Beekeeper Studio

Free + open-source (GPLv3), SQL editor with notebooks and visual query builder. Smaller driver set, no MCP, no local AI. Good for small teams; less extensible plugin model than Tabularis.

Software development agency

Build on tabularis with DEV.co software developers

If you manage multi-database environments or want AI-assisted SQL development with local privacy control, test Tabularis in your stack. Verify MCP IDE support and review credential security before production use.

Talk to DEV.co

Related open-source tools

Surfaced by semantic similarity across the DEV.co open-source index.

ktx mysql_mcp_server mcp-toolbox

Related on DEV.co

Explore the category and the services that help you build with it.

MCP Servers AI-driven application development API development with database integration Talk to DEV.co

tabularis FAQ

Can I use Tabularis to connect to my production database?

Yes, it supports all major RDBMs and many data stores. However, it is early-stage (v0.14). Test thoroughly in non-production first. Implement network ACLs and read-only roles for production access.

Does Tabularis store my database credentials?

Yes, locally in configuration files. Encryption method unknown; requires review. Do not commit credentials to version control. Use environment variables or secrets managers where possible.

Can I deploy Tabularis on a server for my team?

No. Tabularis is desktop-only. Each team member installs locally. For centralized SQL workspace, consider DBeaver Server or web-native tools.

What databases are shipped out of the box?

PostgreSQL, MySQL/MariaDB, SQLite. Additional drivers (ClickHouse, DuckDB, Redis, Firestore, etc.) are installed via the plugin registry. Some are in-progress or on the bounty board.

Custom software development services

DEV.co is a software development agency delivering custom software development services to companies building on open source. Our software developers and web developers design, integrate, and ship production systems — spanning web development, APIs, AI, data, and cloud. If tabularis is part of your mcp servers roadmap, our team can implement, customize, migrate, and maintain it.

Evaluate Tabularis for Your Team

Talk to DEV.co Schedule a Consultation