tabularis
A lightweight, cross-platform database client for developers supporting MySQL, PostgreSQL, SQLite, and plugins.
What is tabularis?
Tabularis is a modern, open-source, cross-platform database client built with Tauri and React. It provides a unified interface for managing multiple database systems like MySQL, PostgreSQL, and SQLite, solving the problem of juggling different tools by combining a visual query builder, AI assistance, and a plugin system into a single application.
Developers and database administrators who work with multiple database systems and need a single, extensible tool for query building, schema exploration, and data management. It is particularly suited for those who value a modern UI, AI-powered features, and the ability to extend support to niche databases via plugins.
Developers choose Tabularis for its combination of a sleek, modern interface with powerful, hackable features like a drag-and-drop visual query builder, optional AI integration for Text-to-SQL, and a plugin system that allows support for any database via JSON-RPC. Its built-in MCP server also enables direct integration with AI agents like Claude Desktop for schema-aware querying.
Overview
Open-source desktop SQL workspace for PostgreSQL, MySQL/MariaDB, SQLite and 15+ more databases like DuckDB, ClickHouse, Redis and Firestore. Built-in MCP server for Claude, Cursor and Devin, SQL notebooks and visual EXPLAIN.
Use Cases
Best For
- Developers who need a single, cross-platform client to manage connections to MySQL, PostgreSQL, and SQLite databases simultaneously.
- Teams looking for a visual query builder with drag-and-drop interface and real-time SQL code generation to simplify complex query construction.
- Users who want to extend database support beyond built-in drivers (e.g., to DuckDB or MongoDB) via an external plugin system using JSON-RPC.
- Developers seeking AI-assisted database workflows, including Text-to-SQL and query explanation, with support for providers like OpenAI, Anthropic, Ollama, and OpenAI-compatible APIs.
- Integrating AI agents (like Claude Desktop or Cursor) directly with live databases via the built-in MCP server for schema reading and query execution.
- Database administrators needing interactive ER diagram visualization for schema exploration and inline editing of table data and structure.
Not Ideal For
- Teams requiring real-time collaborative features like shared query histories or simultaneous editing sessions.
- Environments that need web-based or cloud-hosted database clients for remote access.
- Users who primarily work with a single database type and require deep, specialized tools not yet fully supported (e.g., advanced PostgreSQL extensions).
- Projects with strict security policies that prohibit external plugin installations or AI API integrations due to compliance risks.
Pros & Cons
Pros
Supports MySQL, PostgreSQL, and SQLite with SSH tunneling and secure password storage in a single interface, eliminating the need to switch between different database clients.
Drag-and-drop interface with ReactFlow allows constructing complex queries visually, with real-time SQL generation that speeds up query development without manual coding.
JSON-RPC based plugin system enables adding support for any database like DuckDB or MongoDB via external executables, making the tool highly adaptable to niche workflows.
Optional AI features support multiple providers including OpenAI, Anthropic, Ollama, and OpenAI-compatible APIs, with dynamic model fetching and local LLM options for privacy-conscious users.
Built-in MCP server allows AI agents like Claude Desktop to read schema and execute queries directly, enhancing AI-assisted development with one-click setup for popular clients.
Cons
Key features such as query history, team collaboration, SQL formatting, and visual explain analyze are listed on the roadmap but not yet implemented, limiting utility for advanced users.
Extending database support beyond core drivers relies on external plugins, which may be scarce in the early ecosystem and require custom development, adding setup overhead.
Enabling AI features necessitates configuring API keys or setting up local LLMs like Ollama, which can be a barrier for quick adoption and adds maintenance burden.
As a version 0.9.x project, it may experience breaking changes, limited documentation, and bugs as it evolves, making it less stable than mature alternatives.
Frequently Asked Questions
Related Projects
QdrantQdrant - High-performance, massive-scale Vector Database and Vector Search Engine for the next generation of AI. Also available in the cloud https://cloud.qdrant.io/
SurrealDBA scalable, distributed, collaborative, document-graph database, for the realtime web
RustFS🚀2.3x faster than MinIO for 4KB object payloads. RustFS is an open-source, S3-compatible high-performance object storage system supporting migration and coexistence with other S3-compatible platforms such as MinIO and Ceph.
TursoA SQL database in Rust: SQLite-compatible, now also speaking Postgres (experimental). The LLVM of databases.
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.