Skip to content
Back to search

tabularis

Open-source desktop SQL workspace with 3 built-in database drivers and 16 shipped plugins, including SQL Server, DuckDB, ClickHouse and Redis. Built-in MCP server for Claude, Cursor and Devin, SQL notebooks and visual EXPLAIN.

Safety scan

A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.

Checked today

Check it deeper on your machine

It has changed since its scan on 11 Nov 2026.

As a Claude Code plugin, install it and then ask Claude Code:

/plugin marketplace add keithmackay/mackayi/plugin install scanskillsafety@mackayiDo a deep scan of https://github.com/TabularisDB/tabularis with scanskillsafety

Or from a terminal, clone it and run it:

git clone https://github.com/keithmackay/scanskillsafety-skill ~/.claude/skills/scanskillsafetynode ~/.claude/skills/scanskillsafety/cli.cjs --deep 'https://github.com/TabularisDB/tabularis'

It checks the exact commit: every file, its packages against OSV (api.osv.dev), how it compares with this page's scan (findsafeskills.com receives the repository's address), and, if you agree, Claude reading every file with your own Claude subscription. It never runs the code.

Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/tabularisdb--tabularis/badge.svg)](/listings/tabularisdb--tabularis)

HTML

<a href="/listings/tabularisdb--tabularis"><img src="/api/listings/tabularisdb--tabularis/badge.svg" alt="findsafeskills safety rating" /></a>

Install

i

Install instructions from the README

As written by the repo's author. findsafeskills has not verified these steps.

Windows

WinGet (Recommended)

winget install Debba.Tabularis

Direct Download

Download the installer from the [Releases page](https://github.com/TabularisDB/tabularis/releases) and run it:

tabularis_x.x.x_x64-setup.exe

Follow the on-screen instructions to complete the installation.

macOS

Homebrew (Recommended)

brew install --cask tabularis

Direct Download

Builds from **v0.13.1** onward are signed and notarized by Apple, so they open without any extra steps.

The notes below only apply to **older releases (before v0.13.1)** downloaded directly:

- You need to allow accessibility access (Privacy & Security) to the tabularis app. If you are upgrading and already have tabularis on the allowed list, remove it manually before accessibility access can be granted to the new version. - You may need to run `xattr -c /Applications/tabularis.app` after copying the app to the Applications directory.

Linux (Snap)

sudo snap install tabularis
sudo snap connect tabularis:password-manager-service   # allow keychain access for saved credentials

The `password-manager-service` interface is not auto-connected by the Snap Store yet. Without it, saving a connection fails with a `Platform secure storage failure` error.

Linux (Flatpak)

flatpak remote-add --if-not-exists flatpark https://dl.flatpark.org/flatpark.flatpakrepo
flatpak install flatpark dev.tabularis.Tabularis

Linux (AppImage)

Download the `.AppImage` file from the [Releases page](https://github.com/TabularisDB/tabularis/releases), make it executable and run it:

chmod +x tabularis_x.x.x_amd64.AppImage
./tabularis_x.x.x_amd64.AppImage

Arch Linux (AUR)

yay -S tabularis-bin

What was scanned

The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.

README.md · README · 516 lines

View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)

This file has changed since it was scanned, so this is not exactly the text that was scanned, and no line is marked. The findings are listed with the safety scan above.

  1. <br />
  2. <p align="center">
  3. <img src=".github/assets/banner-light.png#gh-light-mode-only" alt="Tabularis" width="100%">
  4. <img src=".github/assets/banner-dark.png#gh-dark-mode-only" alt="Tabularis" width="100%">
  5. </p>
  6. # Tabularis
  7. Tabularis is an open-source desktop SQL workspace with 3 built-in database drivers and 30 shipped driver plugins, including DuckDB, ClickHouse, Redis and Firestore. Its built-in MCP server lets Claude, Cursor and Devin (formerly Windsurf) read your schema and run queries in the same app you already use.
  8. <p align="center">
  9. <b><a href="https://tabularis.dev">Website</a></b> ·
  10. <b><a href="https://tabularis.dev/wiki">Docs</a></b> ·
  11. <b><a href="https://tabularis.dev/download">Download</a></b> ·
  12. <b><a href="./CHANGELOG.md">Changelog</a></b>
  13. </p>
  14. <br />
  15. <p align="center">
  16. <img src="https://img.shields.io/github/release/TabularisDB/tabularis.svg?style=flat" alt="Release" />
  17. <img src="https://img.shields.io/github/stars/TabularisDB/tabularis?style=flat" alt="Stars" />
  18. <img src="https://img.shields.io/endpoint?url=https%3A%2F%2Fraw.githubusercontent.com%2FTabularisDB%2Ftabularis%2Fdownload-stats%2Fdownloads.json&amp;style=flat" alt="Downloads" />
  19. <img src="https://github.com/TabularisDB/tabularis/workflows/Release/badge.svg" alt="Build & Release" />
  20. <a href="https://www.blacksmith.sh/?utm_source=tabularis&amp;utm_medium=referral&amp;utm_campaign=sponsor"><img src="https://img.shields.io/badge/CI_powered_by-Blacksmith-0B1015?style=flat" height="20" alt="CI powered by Blacksmith" /></a>
  21. <a href="https://discord.com/invite/K2hmhfHRSt"><img src="https://img.shields.io/discord/1502944695808950282?color=5865F2&logo=discord&logoColor=white" alt="Discord" /></a>
  22. <a href="https://gitster.dev/repo/TabularisDB/tabularis"><img src="https://gitster.dev/api/repositories/badge/cmlko1jr60005ne4yh7i7oy3e" alt="Gitster" /></a>
  23. <br />
  24. <a href="https://snapcraft.io/tabularis"><img src="https://img.shields.io/badge/snap-tabularis-blue?logo=snapcraft" alt="Snap Store" /></a>
  25. <a href="https://flatpark.org/apps/dev.tabularis.Tabularis/"><img src="https://img.shields.io/badge/flatpak-tabularis-4A90D9?logo=flatpak&logoColor=white" alt="Flatpak (Flatpark)" /></a>
  26. <a href="https://aur.archlinux.org/packages/tabularis-bin"><img src="https://img.shields.io/badge/AUR-tabularis--bin-1793D1?logo=archlinux&logoColor=white" alt="AUR" /></a>
  27. <a href="https://winstall.app/apps/Debba.Tabularis"><img src="https://img.shields.io/winget/v/Debba.Tabularis?label=WinGet&logo=windows&color=0078D4" alt="WinGet" /></a>
  28. </p>
  29. <p align="center">
  30. <a href="https://vercel.com/open-source-program"><img alt="Vercel OSS Program" src="https://vercel.com/oss/program-badge-2026.svg" /></a>
  31. </p>
  32. <p align="center">
  33. <sub>
  34. <a href="./README.md">English</a> ·
  35. <a href="./docs/translations/README.it.md">Italiano</a> ·
  36. <a href="./docs/translations/README.es.md">Español</a> ·
  37. <a href="./docs/translations/README.zh-CN.md">中文</a> ·
  38. <a href="./docs/translations/README.fr.md">Français</a> ·
  39. <a href="./docs/translations/README.de.md">Deutsch</a> ·
  40. <a href="./docs/translations/README.ja.md">日本語</a> ·
  41. <a href="./docs/translations/README.ru.md">Русский</a> ·
  42. <a href="./docs/translations/README.tl.md">Tagalog</a> ·
  43. <a href="./docs/translations/README.ko.md">한국어</a> ·
  44. <a href="./docs/translations/README.pt-BR.md">Português (Brasil)</a>
  45. </sub>
  46. </p>
  47. <br />
  48. <div align="center">
  49. <img src="https://raw.githubusercontent.com/TabularisDB/website/main/public/img/overview.gif" alt="Tabularis, a desktop SQL workspace, showing its query editor and data grid" />
  50. </div>
  51. ## Download
  52. ```bash
  53. winget install Debba.Tabularis # Windows
  54. brew install --cask tabularis # macOS
  55. sudo snap install tabularis # Linux
  56. ```
  57. Or grab an installer directly:
  58. - **Windows:** [![Windows](https://img.shields.io/badge/Windows-Download-blue?logo=windows)](https://github.com/TabularisDB/tabularis/releases/download/v0.33.0/tabularis_0.33.0_x64-setup.exe)
  59. - **macOS:** [![macOS (Apple Silicon)](https://img.shields.io/badge/macOS-Apple%20Silicon-black?logo=apple)](https://github.com/TabularisDB/tabularis/releases/download/v0.33.0/tabularis_0.33.0_aarch64.dmg) [![macOS (Intel)](https://img.shields.io/badge/macOS-Intel-black?logo=apple)](https://github.com/TabularisDB/tabularis/releases/download/v0.33.0/tabularis_0.33.0_x64.dmg)
  60. - **Linux:** [![Linux AppImage](https://img.shields.io/badge/Linux-AppImage-green?logo=linux)](https://github.com/TabularisDB/tabularis/releases/download/v0.33.0/tabularis_0.33.0_amd64.AppImage) [![Linux .deb](https://img.shields.io/badge/Linux-.deb-orange?logo=debian)](https://github.com/TabularisDB/tabularis/releases/download/v0.33.0/tabularis_0.33.0_amd64.deb) [![Linux .rpm](https://img.shields.io/badge/Linux-.rpm-red?logo=redhat)](https://github.com/TabularisDB/tabularis/releases/download/v0.33.0/tabularis-0.33.0-1.x86_64.rpm)
  61. The app UI is available in English, Italian, Spanish, Chinese (Simplified), Chinese (Traditional), French, German, Japanese, Russian, Korean, Tagalog, Portuguese (Brazilian) and Vietnamese.
  62. > [!TIP]
  63. > **Discord:** [Join our Discord server](https://discord.com/invite/K2hmhfHRSt) to talk with the maintainers, share feedback, and get help from the community.
  64. ## Table of Contents
  65. - [Why tabularis?](#why-tabularis)
  66. - [Database support](#database-support)
  67. - [Installation](#installation)
  68. - [Windows](#windows)
  69. - [macOS](#macos)
  70. - [Linux (Snap)](#linux-snap)
  71. - [Linux (Flatpak)](#linux-flatpak)
  72. - [Linux (AppImage)](#linux-appimage)
  73. - [Arch Linux (AUR)](#arch-linux-aur)
  74. - [Updates](#updates)
  75. - [Discord](#discord)
  76. - [Changelog](#changelog)
  77. - [Features](#features)
  78. - [Connection Management](#connection-management)
  79. - [Database Explorer](#database-explorer)
  80. - [SQL Editor](#sql-editor)
  81. - [SQL Notebooks](#sql-notebooks)
  82. - [Keyboard Shortcuts](#keyboard-shortcuts)
  83. - [Visual Query Builder](#visual-query-builder)
  84. - [Visual EXPLAIN](#visual-explain)
  85. - [Data Grid](#data-grid)
  86. - [Plugin System](#plugin-system)
  87. - [Logging](#logging)
  88. - [Configuration Storage](#configuration-storage)
  89. - [AI Features (Optional)](#ai-features-optional)
  90. - [MCP Server: AI Agent Integration](#mcp-server-ai-agent-integration)
  91. - [Tech Stack](#tech-stack)
  92. - [Development](#development)
  93. - [Roadmap](#roadmap)
  94. - [Contributing](#contributing)
  95. - [Sponsors and supporters](#sponsors-and-supporters)
  96. - [Origin Story](#origin-story)
  97. - [License](#license)
  98. ## Why tabularis?
  99. | | **tabularis** | DBeaver CE | TablePlus | Beekeeper Studio |
  100. | ------------------------------------------------------------------ | :------------------------------: | :----------------------------: | :----------------: | :-------------------: |
  101. | License | Apache 2.0, free | Apache 2.0, free (Pro is paid) | Commercial | GPLv3 (paid editions) |
  102. | SQL notebooks (SQL + Markdown cells, cross-cell variables, charts) | ✅ | ❌ | ❌ | ❌ |
  103. | Built-in MCP server for AI agents | ✅ | ❌ | ❌ | ❌ |
  104. | Plugins in **any language** (JSON-RPC over stdio) | ✅ | Java/Eclipse plugins | JavaScript plugins | ❌ |
  105. | AI text-to-SQL with **local models** (Ollama) | ✅ | Cloud-based AI assistant | ❌ | ❌ |
  106. | Visual EXPLAIN with interactive plan graphs | ✅ | ✅ | ❌ | ❌ |
  107. | Databases out of the box | 3 built-in + 30 driver plugins | 100+ | 20+ | ~10 |
  108. > [!NOTE]
  109. > Comparison as of June 2026; features in other tools may have changed since. If you need dozens of drivers, use DBeaver. Tabularis focuses on doing a few databases well.
  110. ### Database support
  111. PostgreSQL, MySQL/MariaDB and SQLite ship built in. Everything else is a plugin. The built-in PostgreSQL driver is deprecated in favour of the [PostgreSQL plugin](https://github.com/TabularisDB/tabularis-postgresql-plugin), which Tabularis installs automatically. Current coverage, mirroring the [driver & plugin coverage](https://tabularis.dev/plugins/drivers) on the website:
  112. **Shipped**
  113. | Database | Plugin | Database | Plugin |
  114. | ------------------------ | ----------------------------------------------------------------------------------------------- | -------------- | ----------------------------------------------------------------------------------------------- |
  115. | Google BigQuery | [tabularis-bigquery-plugin](https://github.com/TabularisDB/tabularis-bigquery-plugin) | CockroachDB | [tabularis-cockroachdb-plugin](https://github.com/TabularisDB/tabularis-cockroachdb-plugin) |
  116. | ClickHouse | [tabularis-clickhouse-plugin](https://github.com/TabularisDB/tabularis-clickhouse-plugin) | LibSQL / Turso | [tabularis-libsql-plugin](https://github.com/TabularisDB/tabularis-libsql-plugin) |
  117. | Cloudflare D1 | [tabularis_cloudflare_d1_plugin](https://github.com/josejorge/tabularis_cloudflare_d1_plugin) | MongoDB | [tabularis-mongodb-plugin](https://github.com/danielnuld/tabularis-mongodb-plugin) |
  118. | Cloudflare D1 (HTTP API) | [cloudflare-tabularis](https://github.com/GabrielMalava/cloudflare-tabularis) | MongoDB Atlas | [tabularis-mongodb-plugin](https://github.com/TabularisDB/tabularis-mongodb-plugin) |
  119. | DM / Dameng | [tabularis-dameng-plugin](https://github.com/haos666/tabularis-dameng-plugin) | Oracle | [tabularis-oracle-plugin](https://github.com/TabularisDB/tabularis-oracle-plugin) |
  120. | DuckDB | [tabularis-duckdb-plugin](https://github.com/TabularisDB/tabularis-duckdb-plugin) | Redis (Go) | [tabularis-redis-plugin-go](https://github.com/gzamboni/tabularis-redis-plugin-go) |
  121. | DynamoDB | [tabularis-dynamodb-plugin](https://github.com/TabularisDB/tabularis-dynamodb-plugin) | Redis (Rust) | [tabularis-redis-plugin](https://github.com/nicholas-papachriston/tabularis-redis-plugin) |
  122. | Elasticsearch | [tabularis-elasticsearch-plugin](https://github.com/TabularisDB/tabularis-elasticsearch-plugin) | SQL Server | [tabularis-sqlserver-plugin](https://github.com/TabularisDB/tabularis-sqlserver-plugin) |
  123. | Firestore | [firestore-tabularis](https://codeberg.org/NewtTheWolf/firestore-tabularis) | CSV Folder | [tabularis-csv-plugin](https://github.com/TabularisDB/tabularis-csv-plugin) |
  124. | IBM Db2 | [tabularis-db2-plugin](https://github.com/TabularisDB/tabularis-db2-plugin) | Google Sheets | [tabularis-google-sheets-plugin](https://github.com/TabularisDB/tabularis-google-sheets-plugin) |
  125. | IBM Informix | [tabularis-informix-plugin](https://github.com/danielnuld/tabularis-informix-plugin) | HackerNews | [tabularis-hackernews-plugin](https://github.com/TabularisDB/tabularis-hackernews-plugin) |
  126. | Cassandra / ScyllaDB | [tabularis-cassandra-plugin](https://github.com/TabularisDB/tabularis-cassandra-plugin) | Harper | [tabularis-harper-plugin](https://github.com/HarperFast/tabularis-harper-plugin) |
  127. | PostgreSQL | [tabularis-postgresql-plugin](https://github.com/TabularisDB/tabularis-postgresql-plugin) | Trino | [tabularis-trino-plugin](https://github.com/TabularisDB/tabularis-trino-plugin) |
  128. | Meilisearch | [meilisearch-tabularis](https://github.com/NewtTheWolf/meilisearch-tabularis) | OpenSearch | [tabularis-opensearch-plugin-go](https://github.com/Xrondev/tabularis-opensearch-plugin-go) |
  129. | SurrealDB | [tabularis-surrealdb-plugin](https://github.com/TabularisDB/tabularis-surrealdb-plugin) | Firebird | [tabularis-firebird-plugin](https://github.com/TabularisDB/tabularis-firebird-plugin) |
  130. **On the bounty board**
  131. | Status | Databases |
  132. | ----------- | ---------------------------------------------------------------------------- |
  133. | In progress | InfluxDB |
  134. | Coming soon | Snowflake |
  135. | Scoped | Amazon Redshift, TiDB |
  136. | Open | Etcd, SQL Anywhere |
  137. > [!NOTE]
  138. > **Shipped** drivers are installable from the [plugin registry](https://tabularis.dev/plugins). Everything else is on the [bounty board](https://tabularis.dev/plugins/bounties): claim one, sponsor one, or [request a database](https://github.com/TabularisDB/tabularis/discussions).
  139. Published plugins also include [Neon](https://registry.tabularis.dev/plugins/neon) for cloud database management and [Google Gemini](https://registry.tabularis.dev/plugins/gemini) as an AI assistant, alongside 6 themes. These are separate from the 30 database driver plugins.
  140. ## Installation
  141. ### Windows
  142. **WinGet (Recommended)**
  143. ```bash
  144. winget install Debba.Tabularis
  145. ```
  146. **Direct Download**
  147. Download the installer from the [Releases page](https://github.com/TabularisDB/tabularis/releases) and run it:
  148. ```
  149. tabularis_x.x.x_x64-setup.exe
  150. ```
  151. Follow the on-screen instructions to complete the installation.
  152. ### macOS
  153. **Homebrew (Recommended)**
  154. ```bash
  155. brew install --cask tabularis
  156. ```
  157. [![Homebrew](https://img.shields.io/badge/Homebrew-Repository-orange?logo=homebrew)](https://github.com/debba/homebrew-tabularis)
  158. **Direct Download**
  159. Builds from **v0.13.1** onward are signed and notarized by Apple, so they open without any extra steps.
  160. <details>
  161. <summary>Notes for releases before v0.13.1</summary>
  162. <br />
  163. The notes below only apply to **older releases (before v0.13.1)** downloaded directly:
  164. - You need to allow accessibility access (Privacy & Security) to the tabularis app. If you are upgrading and already have tabularis on the allowed list, remove it manually before accessibility access can be granted to the new version.
  165. - You may need to run `xattr -c /Applications/tabularis.app` after copying the app to the Applications directory.
  166. </details>
  167. ### Linux (Snap)
  168. ```bash
  169. sudo snap install tabularis
  170. sudo snap connect tabularis:password-manager-service # allow keychain access for saved credentials
  171. ```
  172. > [!IMPORTANT]
  173. > The `password-manager-service` interface is not auto-connected by the Snap Store yet. Without it, saving a connection fails with a `Platform secure storage failure` error.
  174. [![Snap Store](https://img.shields.io/badge/snap-tabularis-blue?logo=snapcraft)](https://snapcraft.io/tabularis)
  175. ### Linux (Flatpak)
  176. ```bash
  177. flatpak remote-add --if-not-exists flatpark https://dl.flatpark.org/flatpark.flatpakrepo
  178. flatpak install flatpark dev.tabularis.Tabularis
  179. ```
  180. [![Flatpak (Flatpark)](https://img.shields.io/badge/flatpak-tabularis-4A90D9?logo=flatpak&logoColor=white)](https://flatpark.org/apps/dev.tabularis.Tabularis/)
  181. ### Linux (AppImage)
  182. Download the `.AppImage` file from the [Releases page](https://github.com/TabularisDB/tabularis/releases), make it executable and run it:
  183. ```bash
  184. chmod +x tabularis_x.x.x_amd64.AppImage
  185. ./tabularis_x.x.x_amd64.AppImage
  186. ```
  187. ### Arch Linux (AUR)
  188. ```bash
  189. yay -S tabularis-bin
  190. ```
  191. ## Updates
  192. Tabularis checks for updates automatically on startup and notifies you when a new version is available. You can also download the latest version directly from the [Releases page](https://github.com/TabularisDB/tabularis/releases).
  193. ## Discord
  194. Join our [Discord server](https://discord.com/invite/K2hmhfHRSt) to talk with the maintainers, share feedback, suggest features, or get help from the community.
  195. ## Changelog
  196. Every release is documented in [CHANGELOG.md](./CHANGELOG.md).
  197. ## Features
  198. ### Connection Management
  199. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/connections)</sub>
  200. - Support for **MySQL/MariaDB**, **PostgreSQL** (with multi-schema support) and **SQLite**, with multi-database selection per connection.
  201. - Save, manage, and clone connection profiles, with optional secure password storage in the system **Keychain**.
  202. - **SSH Tunneling** with automatic readiness detection.
  203. - **Per-Connection Appearance:** override the icon ([Lucide](https://lucide.dev/icons/), emoji, or custom image) and accent color of each saved connection.
  204. ### Database Explorer
  205. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/schema-management)</sub>
  206. - **Tree View:** Browse tables, columns, keys, indexes, views, and stored routines, with inline editing from the sidebar.
  207. - **ER Diagram:** Interactive Entity-Relationship visualization (pan, zoom, layout) with selective table diagram generation.
  208. - **Context Actions:** Show data, count rows, modify schema, duplicate/delete tables.
  209. - **SQL Dump & Import:** Export and restore databases with a single flow.
  210. - **Table Export & Import:** Save one table, its structure and rows, as a SQL file and import it into any connection that uses the same driver, from the sidebar or the command palette.
  211. ### SQL Editor
  212. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/editor)</sub>
  213. - **Monaco Editor** with syntax highlighting and auto-completion, in a tabbed interface with isolated connections per tab and resizable **split view**.
  214. - **Multi-Statement Execution:** Run All, Run Selected, or pick individual queries. Results appear in separate tabs with independent pagination.
  215. - **Smart Query Splitting:** Correctly handles stored procedures, functions, and `$$`-delimited blocks.
  216. - **SQL Files:** Open, edit, and save `.sql`, `.psql`, and `.pgsql` files in editor tabs without executing them.
  217. - **Saved Queries** and an **AI assist overlay** directly in the editor.
  218. ### SQL Notebooks
  219. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/notebooks)</sub>
  220. - **Multi-Cell Workspace:** Combine SQL and Markdown cells in a single document, with inline results and bar/line/pie charts.
  221. - **Cross-Cell Variables:** Reference another cell's full result as a table with `{{cell_N}}` (expanded to a CTE at run time), plus global `@paramName` parameters.
  222. - **Run All:** Sequential execution with stop-on-error option and completion summary.
  223. - **Persistence & Export:** Auto-saved as `.tabularis-notebook` files; export as HTML, CSV, or JSON.
  224. - Outline panel, drag & drop cell reordering, and AI-generated cell names.
  225. ### Keyboard Shortcuts
  226. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/keyboard-shortcuts)</sub>
  227. - **Built-in shortcuts** for navigation, editor, and data grid actions, platform-aware (`Cmd` on macOS, `Ctrl` on Windows/Linux).
  228. - **Fully customizable:** Remap any non-locked shortcut from **Settings → Keyboard Shortcuts**; overrides persist to `keybindings.json`.
  229. - Hold `Ctrl+Shift` in the sidebar to reveal numbered badges (1–9) for instant connection switching.
  230. ### Visual Query Builder
  231. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/visual-query-builder)</sub>
  232. - **Drag-and-Drop:** Build queries visually with ReactFlow.
  233. - **Visual JOINs:** Connect tables to create relationships.
  234. - **Advanced Logic:** WHERE/HAVING filters, aggregates (COUNT, SUM, AVG), sorting, and limits.
  235. - **Real-time SQL:** Instant code generation.
  236. ### Visual EXPLAIN
  237. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/visual-explain)</sub>
  238. - **Interactive Plan Graphs:** Inspect execution plans as navigable node graphs instead of raw text.
  239. - **Table, Raw, and AI Views:** Switch between exact node metrics, original database output, and optional AI-assisted analysis.
  240. - **Cross-Database Support:** Works with PostgreSQL, MySQL/MariaDB, and SQLite using the best available `EXPLAIN` format per driver.
  241. - **Faster Optimization Loops:** Spot expensive scans, estimate gaps, join behavior, and optimizer choices without leaving the editor.
  242. ### Data Grid
  243. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/data-grid)</sub>
  244. - **Inline & Batch Editing:** Modify cells and commit multiple changes at once; create, delete, and multi-select rows.
  245. - **Export:** Save results as CSV or JSON, or copy selected rows straight to the clipboard.
  246. - **JSON & JSONB Cells:** Syntax-highlighted in the grid, with a dedicated editor window (Tree / Monaco / Raw modes).
  247. - **Spatial Data:** Initial GEOMETRY support for MySQL.
  248. ### Plugin System
  249. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/plugins)</sub>
  250. Tabularis is **hackable with an external plugin system**. Plugins are standalone executables that communicate with the app over **JSON-RPC 2.0 via stdin/stdout**, and can be written in any language.
  251. - **Install Plugins:** Browse and install community drivers from **Settings → Available Plugins**, no restart required.
  252. - **Manage Drivers:** View all registered drivers (built-in and plugins) in **Settings → Installed Drivers** and uninstall plugins with one click.
  253. - **Any Database:** Add support for DuckDB, MongoDB, or any other database by writing or installing a plugin.
  254. - **Plugin Registry:** Browse published drivers, themes, cloud integrations and AI assistants in the [Tabularium catalog](https://tabularis.dev/plugins). The app also loads legacy entries from [`plugins/registry.json`](./plugins/registry.json).
  255. - **Developer Guide:** See [`plugins/PLUGIN_GUIDE.md`](./plugins/PLUGIN_GUIDE.md) to build your own driver in any language.
  256. - **Declarative themes (development):** **Settings → Appearance** supports local packages (**Import theme → Local package**), previews and personal/VS Code imports without executable plugin activation. See the [theme author guide](./packages/create-plugin/THEMES.md) for the separate `tabularis-theme` CLI, packaging and release gates; public runtime/tooling rollout is not implied by this development feature.
  257. ### Logging
  258. - Real-time log viewer in Settings, with level filtering and export to `.log` files.
  259. - Automatically expand and inspect SQL queries in logs.
  260. - **CLI Debug Mode:** Start with `tabularis --debug` for verbose logging from launch.
  261. ### Configuration Storage
  262. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/configuration)</sub>
  263. Configuration is stored in `~/.config/tabularis/` (Linux), `~/Library/Application Support/tabularis/` (macOS), or `%APPDATA%\tabularis\` (Windows): connection profiles, saved queries, app settings (`config.json`), custom themes, and per-connection editor preferences. You can move this folder from **Settings > Storage** (or with the `TABULARIS_DATA_DIR` environment variable), for example to an iCloud Drive or Dropbox folder to sync connections across machines; installed plugins always stay local. Tabs and queries are restored when you reopen a connection. The wiki covers the full file layout and every `config.json` option, including custom AI model overrides.
  264. <details>
  265. <summary>How Follow System works on Linux</summary>
  266. <br />
  267. On Linux, **Follow System** reads the XDG desktop settings portal's `org.freedesktop.appearance/color-scheme` preference and follows its live updates, including GNOME's dark-mode toggle with the standard Adwaita GTK theme. The resolved light/dark theme is applied explicitly to GTK window decorations and the webview. A portal value of `0` (no preference) resolves to light, so switching back to the desktop default cannot reuse the app's previously forced dark theme. If the portal is unavailable or returns an unsupported value, Tabularis falls back to the native window theme, then the browser media query. The default window capability grants `core:window:allow-set-theme` to allow native theme changes. macOS and Windows use native theme notifications. See [the portal specification](https://flatpak.github.io/xdg-desktop-portal/docs/doc-org.freedesktop.portal.Settings.html).
  268. Portal command reads reuse one cached D-Bus connection, while the live watcher keeps its own connection. Failed reads discard the cached connection so the next request can reconnect; failed connection attempts are not cached. The existing two-second command timeout also bounds concurrent requests waiting for the cache.
  269. </details>
  270. ### AI Features (Optional)
  271. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/ai-assistant)</sub>
  272. Optional Text-to-SQL and query explanation powered by **OpenAI**, **Anthropic**, **MiniMax**, **OpenRouter**, **Requesty**, **API Route**, **Ollama** (local models, no API key, full privacy), and any **OpenAI-compatible API** (Groq, Perplexity, Azure OpenAI, LocalAI, ...). Model lists are fetched from your provider and cached locally; custom models can be configured per provider.
  273. To use [API Route](https://www.api-route.com), open **Settings > AI**, enable AI and select **API Route**. Save your API Route key, refresh the model list and choose a default model. Alternatively, set `API_ROUTE_API_KEY` in the environment of the desktop app or web server. The integration uses `https://global.api-route.com/v1/models` and `/chat/completions`; model access and billing depend on your API Route account. The provider's proxy settings apply to both endpoints. Adding API Route does not change existing provider selections.
  274. The existing providers are **built in** and remain available offline. Install
  275. additional providers, including **Google Gemini**, directly from **Settings → AI**
  276. with **Install and use**, or manage external packages in the Plugin Center.
  277. All API-key providers share a declarative HTTP runtime; existing credentials,
  278. models, endpoints and proxy settings are preserved on upgrade. ChatGPT account
  279. login remains built in.
  280. To publish a provider, see the [AI assistant package guide](plugins/ai-assistants/README.md).
  281. ### MCP Server: AI Agent Integration
  282. <sub>[Full reference on tabularis.dev →](https://tabularis.dev/wiki/mcp-server)</sub>
  283. Tabularis includes a built-in **MCP (Model Context Protocol) server** that lets AI agents read your database schema and execute queries directly from their chat interface.
  284. ```bash
  285. tabularis --mcp
  286. ```
  287. **One-click setup** for Claude Desktop, Cursor, and Windsurf: open **Settings → MCP Server Integration**, click **Install Config** next to your client, and restart it. Manual configuration is covered in the wiki.
  288. #### Available tools
  289. Once connected, your AI agent can:
  290. | Tool | Description |
  291. | ------------------ | --------------------------------------------------------- |
  292. | `list_connections` | List all saved database connections |
  293. | `list_databases` | List all databases available for a connection |
  294. | `list_tables` | List tables in a connection (with optional schema filter) |
  295. | `describe_table` | Get full schema: columns, indexes, foreign keys |
  296. | `run_query` | Execute any SQL query and return results |
  297. Every tool accepts an optional `output_format` argument. JSON is the default, preserving the existing response format for all clients. You can choose JSON or [TOON](https://toonformat.dev/) as the default under **Settings → MCP Server Integration**; a tool call's `output_format` argument overrides that preference. TOON is especially compact for tabular query results passed to an LLM. MCP transport remains JSON-RPC in either mode; only the text inside the tool result changes.
  298. #### Example prompts
  299. > "Show me all tables in my production database and describe the `orders` table"
  300. > "Write and run a query to find the top 10 customers by total order value this month"
  301. > "Check if there are any missing indexes on the `users` table"
  302. ## Tech Stack
  303. | Layer | Stack |
  304. | -------- | ------------------------------------- |
  305. | Frontend | React 19, TypeScript, Tailwind CSS v4 |
  306. | Backend | Rust, Tauri v2, SQLx |
  307. ## Development
  308. **Setup**
  309. ```bash
  310. pnpm install
  311. pnpm tauri dev
  312. ```
  313. **Build**
  314. ```bash
  315. pnpm tauri build
  316. ```
  317. ## Roadmap
  318. - [x] [Plugin registry platform — OAuth publishing, release sync, download analytics](https://github.com/TabularisDB/tabularis/issues/196)
  319. - [x] [SQL Server driver — implementation roadmap & call for contributors](https://github.com/TabularisDB/tabularis/issues/150)
  320. - [x] [[Feat]: Allow loading of multiple Databases per connection](https://github.com/TabularisDB/tabularis/issues/47)
  321. - [x] [Command Palette](https://github.com/TabularisDB/tabularis/issues/25)
  322. - [x] [JSON/JSONB Editor & Viewer](https://github.com/TabularisDB/tabularis/issues/24)
  323. - [x] [SQL Formatting / Prettier](https://github.com/TabularisDB/tabularis/issues/23)
  324. - [x] [Visual Explain Analyze](https://github.com/TabularisDB/tabularis/issues/22)
  325. - [x] [Plugin System](https://github.com/TabularisDB/tabularis/issues/19)
  326. - [x] [Query History](https://github.com/TabularisDB/tabularis/issues/18)
  327. - [ ] [UI design system & visual identity — call for contributors](https://github.com/TabularisDB/tabularis/issues/195)
  328. - [ ] [Feature: Remote Control](https://github.com/TabularisDB/tabularis/issues/46)
  329. - [ ] [Data Compare / Diff Tool](https://github.com/TabularisDB/tabularis/issues/21)
  330. - [ ] [Team Collaboration](https://github.com/TabularisDB/tabularis/issues/20)
  331. - [ ] [Better SQLite Support](https://github.com/TabularisDB/tabularis/issues/17)
  332. - [ ] [Better PostgreSQL Support](https://github.com/TabularisDB/tabularis/issues/16)
  333. ## Contributing
  334. Contributions are welcome, see [CONTRIBUTING.md](./CONTRIBUTING.md). Good places to start:
  335. - [UI design system & visual identity: call for contributors](https://github.com/TabularisDB/tabularis/issues/195)
  336. - Write a driver plugin in any language with the [Plugin Guide](./plugins/PLUGIN_GUIDE.md)
  337. <!-- SPONSORS:START -->
  338. ## Sponsors and supporters
  339. - <a href="https://www.serversmtp.com/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/turbosmtp_compact.png" height="28" alt="turboSMTP" /></a> **[turboSMTP](https://www.serversmtp.com/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Professional SMTP relay that delivers your emails straight to the inbox, never to spam
  340. - <a href="https://www.kilo.ai/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/kilocode_compact.png" height="28" alt="Kilo Code" /></a> **[Kilo Code](https://www.kilo.ai/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Open source AI coding agent to build, ship, and iterate faster with 500+ models
  341. - <a href="https://openai.com/codex/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/openai_compact.png" height="28" alt="OpenAI" /></a> **[OpenAI](https://openai.com/codex/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Supporting Tabularis through the Codex for Open Source program.
  342. - <a href="https://claude.com/programs/startups?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/anthropic_compact.png" height="28" alt="Anthropic" /></a> **[Anthropic](https://claude.com/programs/startups?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Supporting Tabularis through the Claude for Startups program.
  343. - <a href="https://neon.com/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/neon_compact.svg" height="28" alt="Neon" /></a> **[Neon](https://neon.com/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Managed Postgres with database branching, supporting Tabularis through the Neon Open Source Program.
  344. - <a href="https://www.blacksmith.sh/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/blacksmith_compact.svg" height="28" alt="Blacksmith" /></a> **[Blacksmith](https://www.blacksmith.sh/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Faster, cheaper GitHub Actions runners, powering the CI behind Tabularis.
  345. - <a href="https://m.do.co/c/f6ab3d158275?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/digitalocean_compact.png" height="28" alt="DigitalOcean" /></a> **[DigitalOcean](https://m.do.co/c/f6ab3d158275?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Simple, predictable cloud infrastructure for developers and growing teams.
  346. - <a href="https://vercel.com/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/vercel_compact.svg" height="28" alt="Vercel" /></a> **[Vercel](https://vercel.com/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — The platform for the modern web: ship, preview, and scale frontend apps with zero config.
  347. - <a href="https://usero.io/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/usero_compact.png" height="28" alt="Usero" /></a> **[Usero](https://usero.io/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Feedback becomes code. Automatically.
  348. - <a href="https://devglobe.app/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/devglobe_compact.png" height="28" alt="DevGlobe" /></a> **[DevGlobe](https://devglobe.app/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Connect your IDE, show up on the globe, and showcase your projects to a community of builders.
  349. - <a href="https://tolgee.io/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/tolgee_compact.svg" height="28" alt="Tolgee" /></a> **[Tolgee](https://tolgee.io/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Open-source localization platform to translate your app in context, without the spreadsheet chaos.
  350. - <a href="https://1password.com/developers?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/1password_compact.png" height="28" alt="1Password" /></a> **[1Password](https://1password.com/developers?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — The password and secrets manager developers trust, free for open-source projects.
  351. - <a href="https://www.jetbrains.com/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/jetbrains_compact.png" height="28" alt="JetBrains" /></a> **[JetBrains](https://www.jetbrains.com/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Professional developer tools: IntelliJ IDEA, WebStorm, DataGrip and the rest of the All Products Pack.
  352. - <a href="https://signpath.io/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor" target="_blank"><img src="https://tabularis.dev/img/logos/sponsors/signpath_compact.png" height="28" alt="SignPath" /></a> **[SignPath](https://signpath.io/?utm_source=tabularis&utm_medium=referral&utm_campaign=sponsor)** — Code signing for open source: signed Windows releases without the certificate bill.
  353. _[Become a sponsor →](https://tabularis.dev/sponsors)_
  354. <!-- SPONSORS:END -->
  355. ## Origin Story
  356. Tabularis started as an experiment: how far could AI-assisted development get in building a working tool from scratch? Further than expected: it's now an actively maintained project with regular releases and a plugin ecosystem.
  357. ## License
  358. [Apache License 2.0](./LICENSE)
  359. ---
  360. <p align="center">
  361. Like tabularis? <a href="https://github.com/TabularisDB/tabularis">Star the repo</a> ⭐, it helps the project a lot.
  362. </p>
  363. <p align="center">
  364. <a href="https://repostars.dev/?repos=TabularisDB%2Ftabularis&theme=dark">
  365. <img src="https://repostars.dev/api/embed?repo=TabularisDB%2Ftabularis&theme=dark" alt="RepoStars" />
  366. </a>
  367. </p>

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.