Tabularis combines a desktop SQL editor, editable results, schema diagrams, and notebooks with SQL and Markdown cells. Its optional MCP server, a standard connection between agents and tools, exposes saved database connections to compatible assistants.

  • Inspect and explain data. Browse tables and indexes, edit rows, export CSV or JSON, and view query execution plans as graphs.
  • Keep analysis together. Notebooks combine queries, notes, charts, and references to earlier cells’ results.
  • Add database drivers. MySQL/MariaDB, SQLite, and PostgreSQL are listed as built-in. The README now recommends the automatically installed PostgreSQL plugin; other databases use plugins.
  • Reuse connections with an agent. Run tabularis --mcp to expose schema tools and query execution over local standard input/output.

The project provides Windows, macOS, and Linux packages, including AppImage, Debian, and RPM downloads. Its React interface runs on Tauri and Rust. Source development uses pnpm and the Tauri toolchain. The Apache-2.0 licence permits commercial reuse under its notice requirements.

SQL notebooks make this worth a look for repeat investigations that otherwise scatter across query tabs and separate notes. AI assistance is optional, with local Ollama support alongside hosted providers.

Caveat: agent query tools can execute destructive SQL; use the documented read-only controls and a restricted database account before exposing valuable data. A local MCP transport does not keep results private once a hosted assistant receives them.

Discovered through the developer’s r/BestGitHubRepos post. Feature details come from the current README and first-party MCP documentation.