Changelog

Every release, documented. Follow what's new, improved, and fixed.

Latest

v0.2.2

Fixes

  • The Trino schema browser lists the tables of large catalogs again: the table list no longer waits on the metadata of every column, and columns that cannot be read in time are skipped instead of hiding the whole catalog
  • Columns no longer appear twice in the Trino schema browser with some connectors when no schema is pinned on the connection

v0.2.1

Fixes

  • The web app works when served over plain HTTP on an intranet address (no TLS certificate): it no longer crashes at startup with crypto.randomUUID is not a function, and copying works there too

v0.2.0 — Nine databases

5 New Database Drivers

  • SQL Server — T-SQL with GO batches, named instances and Azure SQL, stored procedures and functions in the schema browser, CSV import and SQL dump
  • Snowflake — password or key-pair authentication, warehouse and role per connection; the schema is browsed with SHOW commands, without waking up the warehouse
  • MongoDB — mongosh syntax (find, aggregate, writes, indexes), parsed and never evaluated; Atlas and replica-set URIs; CSV import into collections
  • Redis — redis-cli syntax, key prefixes browsed as tables, keys renamed, expired and edited from the grid
  • Trino — federated catalogs, catalog and schema switching from the database selector

SQL Editor

  • Multi-statement scripts run in one session, with one result tab per statement — transactions and session settings behave as in the native client
  • Server-side sort and paging keep the query's own LIMIT and ORDER BY
  • The result total comes with the result on Snowflake and Redis: no second query to count rows

AI Copilot

  • Mistral provider
  • Dialect rules for T-SQL, Snowflake, Trino, mongosh and redis-cli, so that suggestions run as written

Safety & Fixes

  • Guardrails ignore keywords inside strings and comments, and judge every statement of a script
  • Redis FLUSHDB / FLUSHALL and MongoDB deleteMany() ask for confirmation like a SQL DROP
  • Session state (SET, USE, open transactions, temporary tables) never leaks to other users of a pooled connection
  • Credentials found in connection URIs are moved to the encrypted password field

v0.1.0 — Initial Release

SQL Editor

  • Multi-tab SQL editor powered by CodeMirror 6 with syntax highlighting
  • Schema-aware autocomplete on tables, columns, joins, and relationships
  • EXPLAIN plan analysis with visual breakdown
  • Streaming query results via SSE — no timeout on long queries
  • Export results to CSV, JSON, or SQL
  • CSV & SQL dump import with AI-powered column mapping

4 Database Drivers

  • PostgreSQL, MySQL, Oracle, and SQLite supported out of the box
  • Seamless multi-driver experience — switch databases without leaving the window
  • Connection pooling and credential encryption (AES-256-GCM)
  • SSL/TLS support for all drivers

AI Copilot

  • Natural language → working SQL, grounded in your schema
  • Explain, optimize, or debug any query in-place
  • BYOK — Anthropic Claude, OpenAI, Azure OpenAI, or local Ollama
  • Streaming responses via SSE
  • Your prompts go directly to the provider — dblumi never proxies or stores them

Collaboration & Sharing

  • Real-time collaborative editing with Yjs + WebSocket — see cursors and edits live
  • Save queries to your workspace with folders, tags, and team sharing
  • Full version history — browse the timeline, diff any two versions, restore in one click
  • Role-based access control: Admin, Editor, Viewer per connection
  • Group-based sharing with color tagging

Schema & Data

  • Interactive schema browser with search
  • Auto-generated entity-relationship diagrams
  • Table explorer with inline editing
  • Database user management per connection
  • Data sync between databases (multi-table)

Security & Administration

  • 4 safety levels — from unrestricted dev to fully locked production
  • Destructive query detection with confirmation flow
  • JWT authentication with token revocation
  • SSO via GitHub, Google, Keycloak/OIDC
  • Admin panel for user management and instance configuration
  • Password strength indicator and forgot-password flow (SMTP)

REST API & Integrations

  • Full REST API (v1) for every resource
  • Interactive Swagger UI with OpenAPI 3.0 spec
  • Turn any saved query into a JSON endpoint with named parameters and API keys

Self-hosting

  • Docker Compose in 30 seconds
  • AGPL-3.0 — every feature, forever free
  • 100% self-hosted — your data never leaves your network
  • Environment-based configuration

UI & DX

  • Command palette for quick navigation
  • Internationalization — English and French shipped
  • Tailwind CSS v4 design system with Radix UI + shadcn/ui components
  • Geist (sans) + JetBrains Mono (mono) fonts