tabularis

Tabularis is a lightweight, developer-focused database management tool designed to run as a self-contained application. It provides a rich set of features for working with MySQL/MariaDB, PostgreSQL (with multi-schema support), and SQLite, including a database explorer with a tree view of schemas, tables, and views; an SQL editor with syntax highlighting and AI-assisted overlays; a visual query builder; and a data grid for editing and viewing results. The tool consolidates connection management, SQL authoring, and data exploration in a single interface, with support for SSH tunneling and optional secure credential storage. Use Tabularis to connect to your databases, navigate schemas, build and run SQL queries, and visualize the results in real time, all within a desktop-style application built with Tauri and React.

Prerequisites:

• Docker installed and running on your machine.
• Basic familiarity with pulling and running Docker containers.

Installation steps:

1. Ensure Docker is installed:

   • macOS: https://docs.docker.com/desktop/mac/
   • Windows: https://docs.docker.com/desktop/windows/
   • Linux: follow your distro’s guidelines to install the Docker Engine.

2. Pull and run the Tabularis image:

   docker pull debba/tabularis
   docker run -it --rm --name tabularis debba/tabularis
   

3. When the container starts, attach to the running UI process (depending on how the image exposes the UI, you may access a local window or a frontend URL). Follow the container’s logs for the exact access method. If the image exposes a local GUI, ensure your environment can render the UI from the container.

4. Optional: configure persistent storage by mounting a host directory for configuration and database access if supported by the image. Example:

   docker run -it --rm -v /path/to/tabularis/config:/app/config -v /path/to/databases:/app/databases debba/tabularis
   

5. For updates, pull a newer image version and recreate the container following the same run command.

Note: The exact image name and run parameters may vary depending on the official release or packaging. Refer to the Tabularis release notes for container-specific guidance if you intend to deploy via Docker in production.

Tips and considerations:

• Tabularis supports MySQL/MariaDB, PostgreSQL (with multi-schema support), and SQLite; use the Connection Management panel to add new database connections, including SSH tunneling if your database is behind a firewall.
• You can manage multiple databases and connections in a single view, with options to save, clone, and securely store credentials in your system keychain if supported by the build.
• The SQL Editor provides monaco-based editing with syntax highlighting and AI-assisted overlays to help with query composition. Use the Visual Query Builder to graphically construct queries.
• If you encounter UI rendering issues when running inside a Docker container, ensure the container has access to your display or use an image that exposes a web-based frontend that can be viewed in a browser. Check logs for any port mappings or UI host hints.
• For SSH tunneling, configure the SSH details in the Connection Management area to securely reach your remote databases.
• Environment variables and configuration options, if exposed by your container image, may include LOG_LEVEL, DB_DEFAULT_TIMEOUT, and API_ENDPOINT placeholders. Refer to the image documentation for exact variables.