How do I connect Tabularis to my local Ollama instance for AI features?

In Settings, select 'Ollama' as the AI provider. Tabularis automatically detects models running on port 11434, but you can customize the endpoint. No API key is needed, ensuring privacy for local LLM use.

Tabularis vs DBeaver: which is better for PostgreSQL development?

Tabularis offers a modern UI, visual query builder, and AI integration, while DBeaver provides more mature PostgreSQL-specific tools and a larger plugin ecosystem. Choose Tabularis for innovation and extensibility, DBeaver for stability and depth.

Can I write a custom plugin to add support for a niche database in Tabularis?

Yes, Tabularis includes a plugin guide for creating standalone executables in any language using JSON-RPC over stdin/stdout. You can then install it via Settings to extend database support without modifying the core app.

Is Tabularis suitable for team use with shared connections and queries?

Currently, no. Configuration is stored locally per user, and features like team collaboration or shared query histories are on the roadmap but not implemented, so teams would need manual syncing or alternative tools.

How does Tabularis handle performance with large datasets in the data grid?

The data grid supports pagination with configurable page sizes and export to CSV/JSON, but very large result sets may strain local memory as it's a desktop app. Optimizations like filtering are available, but performance limits depend on hardware.

Does Tabularis support database migrations or version control integration?

No, it focuses on query execution, schema exploration, and data management. Users need separate tools for migrations or version control, as these features are not included in the current release or roadmap.

Open-Awesome

tabularis

Apache-2.0TypeScriptv0.10.0

A lightweight, cross-platform database client for developers supporting MySQL, PostgreSQL, SQLite, and plugins.

Visit Website GitHub

1.2k stars80 forks0 contributors

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.

Target Audience

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.

Value Proposition

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

A lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.

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

Multi-Database Unity

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.

Visual Query Builder

Drag-and-drop interface with ReactFlow allows constructing complex queries visually, with real-time SQL generation that speeds up query development without manual coding.

Extensible Plugin Architecture

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.

AI Integration Flexibility

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.

MCP Server Integration

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

Incomplete Feature Set

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.

Plugin Dependency Complexity

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.

AI 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.

Early Development Volatility

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

SurrealDB

A scalable, distributed, collaborative, document-graph database, for the realtime web

Stars31,956

Forks1,251

Last commit2 days ago

Qdrant

Qdrant - 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/

Stars30,831

Forks2,216

Last commit2 hours ago

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.

Stars26,742

Forks1,143

Last commit58 minutes ago

Neon

Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, code-like database branching, and scale to zero.

Stars21,647

Forks940

Last commit1 month ago

Community-curated · Updated weekly · 100% open source

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.

Submit a project Star on GitHub