Skip to content

debba/tabularis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

275 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

tabularis

Build & Release Known Vulnerabilities

A lightweight, developer-focused database management tool, built with Tauri and React.

Tabularis

Release Download:

Windows macOS Linux

Installation

macOS

Homebrew (Recommended)

To add our tap, run:

brew tap debba/tabularis

Then install:

brew install --cask tabularis

Homebrew

Direct Download

When you install tabularis on macOS, you need to allow accessibility access (Privacy & Security) to the tabularis app.

If you are upgrading and you already have tabularis on the allowed list you will need to manually remove them before accessibility access can be granted to the new version.

macOS users who download directly from releases may need to run:

xattr -c /Applications/tabularis.app

after copying the app to the Applications directory.

Arch Linux (AUR)

yay -S tabularis-bin

Updates

Automatic Updates

Tabularis checks for updates automatically on startup. When a new version is available, a notification will appear, allowing you to download and install the update seamlessly.

Manual Updates

You can also manually check for updates or download the latest version directly from the Releases page.

Gallery

View the full gallery at tabularis.dev

Features

Connection Management

  • Support for MySQL/MariaDB, working on: PostgreSQL and SQLite.
  • Save, manage, and clone connection profiles with secure local persistence.
  • Manage SSH Connections from the connection manager.
  • Optional secure password storage in system Keychain.
  • SSH Tunneling with automatic readiness detection.

Database Explorer

  • Tree View: Browse tables, columns, keys, foreign keys, indexes, views, and stored routines.
  • ER Diagram: Interactive Entity-Relationship visualization (Pan, Zoom, Layout) with selective table diagram generation.
  • Context Actions: Show data, count rows, modify schema, duplicate/delete tables.
  • Views Support: Browse, inspect, and query database views with full metadata.
  • Stored Routines: View and manage stored procedures and functions with parameter details.
  • Fast Metadata: Parallel fetching for schema loading.
  • SQL Dump & Import: Export and restore databases with a single flow.

SQL Editor

  • Monaco Editor: Syntax highlighting and auto-completion.
  • Tabbed Interface: Isolated connections per tab.
  • Execution: Run full scripts, selections, or specific statements.
  • Saved Queries: Persist frequently used SQL.

Visual Query Builder

  • Drag-and-Drop: Build queries visually with ReactFlow.
  • Visual JOINs: Connect tables to create relationships.
  • Advanced Logic: WHERE/HAVING filters, aggregates (COUNT, SUM, AVG), sorting, and limits.
  • Real-time SQL: Instant code generation.

Data Grid

  • Inline & Batch Editing: Modify cells and commit multiple changes at once.
  • Row Management: Create, delete, and select multiple rows.
  • Copy Selected Rows: Export selections straight to the clipboard.
  • Export: Save results as CSV or JSON.
  • Smart Context: Read-only mode for aggregates, edit mode for tables.

Logging

  • Real-time Monitoring: View application logs directly in Settings.
  • Level Filtering: Filter by DEBUG, INFO, WARN, or ERROR severity.
  • In-memory Buffer: Configurable retention.
  • Query Expansion: Automatically expand and inspect SQL queries in logs.
  • Export Logs: Save logs to .log files for debugging or audit trails.
  • Toggle Control: Enable/disable logging and adjust buffer size without restart.
  • CLI Debug Mode: Start with tabularis --debug to enable verbose logging (including internal SQLx queries) from launch.

Configuration Storage

Configuration is stored in ~/.config/tabularis/ (Linux), ~/Library/Application Support/tabularis/ (macOS), or %APPDATA%\tabularis\ (Windows).

  • connections.json: Connection profiles.
  • saved_queries.json: Saved SQL queries.
  • config.json: App settings (theme, language, page size).
  • themes/: Custom themes.

config.json options

  • theme: Theme ID (e.g., "tabularis-dark", "monokai").
  • fontFamily: Editor font family.
  • fontSize: Editor font size (px).
  • language: "auto", "en", "it".
  • resultPageSize: Default rows per page.
  • aiEnabled: Enable/Disable AI features.

Custom AI Models override

You can override or add custom models for AI providers by editing config.json and adding the aiCustomModels object:

{
  "resultPageSize": 1000,
  "language": "en",
  "aiEnabled": true,
  "aiProvider": "openai",
  "aiCustomModels": {
    "openai": ["gpt-4o", "gpt-4-turbo", "gpt-3.5-turbo", "gpt-5-preview"],
    "anthropic": ["claude-3-opus-20240229", "claude-3-sonnet-20240229"],
    "openrouter": ["google/gemini-pro-1.5", "meta-llama/llama-3-70b-instruct"]
  }
}

AI Features (Optional)

Optional Text-to-SQL and query explanation powered by:

  • OpenAI
  • Anthropic
  • OpenRouter (access to Gemini, Llama, DeepSeek, etc.)
  • Ollama (Local LLM support for total privacy)
  • OpenAI-Compatible APIs (Groq, Perplexity, Azure OpenAI, LocalAI, and more)

Local AI (Ollama)

Select "Ollama" as your provider in Settings. Tabularis will automatically detect your local models running on port 11434 (configurable). No API key required.

OpenAI-Compatible APIs

Select "OpenAI Compatible" as your provider to connect to any service that implements the OpenAI API format. Configure your custom endpoint URL and model name in Settings. Examples:

  • Groq: https://api.groq.com/openai/v1
  • Perplexity: https://api.perplexity.ai
  • Local servers: http://localhost:8000/v1

Dynamic Model Fetching

Tabularis automatically fetches the latest available models from your configured provider.

  • Refresh: Click the refresh icon in Settings to update the model list from the API.
  • Cache: Model lists are cached locally for 24h to ensure fast startup.
  • Validation: Visual feedback if the selected model is not available for the current provider.

Includes a built-in MCP Server (tabularis --mcp) to expose connections to external agents (Claude Desktop, Cursor).

Tech Stack

  • Frontend: React 19, TypeScript, Tailwind CSS v4.
  • Backend: Rust, Tauri v2, SQLx.

Development

Setup

npm install
npm run tauri dev

Build

npm run tauri build

Roadmap

License

Apache License 2.0