Summary

Tabularis is a lightweight, developer-focused database management tool built with Tauri and React. It addresses the need for a streamlined, cross-platform desktop application for database exploration, SQL editing, and data manipulation, offering advanced features like AI assistance and visual query building to enhance developer productivity.

How It Works

Leveraging Rust with Tauri v2 for a native desktop shell and React 19 with TypeScript for the frontend, Tabularis provides a performant, cross-platform experience. Its architecture emphasizes fast startup and session persistence by saving editor states per connection. Core functionalities include a robust database explorer, an AI-assisted SQL editor powered by Monaco, and a visual query builder utilizing ReactFlow for real-time SQL generation.

Quick Start & Requirements

• macOS: Install via Homebrew (brew tap debba/tabularis && brew install --cask tabularis). Direct downloads require xattr -c /Applications/tabularis.app and potential accessibility permission adjustments.
• Arch Linux: Available via AUR (yay -S tabularis-bin).
• Updates: Automatic on startup or manual via GitHub Releases.
• Prerequisites: None explicitly listed beyond OS-specific installation methods.

Highlighted Details

• AI Integration: Supports Text-to-SQL and query explanation via OpenAI, Anthropic, OpenRouter, or local Ollama, with OpenAI-compatible API support.
• Visual Query Builder: Drag-and-drop interface for constructing queries, generating SQL in real-time.
• Database Explorer: Features an interactive ER diagram viewer, inline editing, support for views/stored routines, and fast metadata fetching.
• SQL Editor: Monaco-based editor with syntax highlighting, auto-completion, split views, and saved queries.
• Data Grid: Supports inline/batch editing, row management, and CSV/JSON export.
• Session Persistence: Editor state (tabs, queries, layout) is automatically saved per connection for seamless session restoration.

Maintenance & Community

Active community engagement is encouraged via a Discord server (https://discord.gg/YrZPHAwMSG). The project utilizes GitHub Actions for CI/CD and includes vulnerability scanning via Snyk.

Licensing & Compatibility

Released under the Apache License 2.0, permitting commercial use and modification with attribution.

Limitations & Caveats

The roadmap indicates several features are under active development, including a Command Palette, JSON/JSONB editor, SQL formatter, Visual Explain Analyze, and Data Compare/Diff tools. Support for PostgreSQL and SQLite is noted as evolving.