Oct 5, 2026
v1.15.0

Live mode for MySQL, SQL Server and SQLite

πŸš€ Features

  • β€’ Live mode now works on MySQL, SQL Server, and SQLite, not just PostgreSQL: the grid refreshes every second and highlights rows and cells that changed - @husamql3

πŸ”§ Improvements

  • β€’ Removed the website's admin dashboard along with its sign-in, analytics API, and charting dependency - @husamql3

πŸ› Bug Fixes

  • β€’ Fixed SQL Server tables without a sort returning rows in storage order instead of primary-key order, which let rows shift between refreshes - @husamql3
  • β€’ Fixed MySQL paging repeating or skipping rows when sorting by a column with duplicate values - @husamql3
  • β€’ Fixed number cells keeping their old value after the table refreshed, on every database; unsaved edits are still preserved - @husamql3
Sep 26, 2026
v1.14.2

Leaner test suite and an up-to-date roadmap

πŸ”§ Improvements

  • β€’ Removed unit tests that could not catch real bugs, keeping the ones that pin down SQL building, error mapping, data parsing, and credential redaction - @husamql3
  • β€’ Added the website's admin authentication tests to the project-wide test run; they had never been running - @husamql3
  • β€’ Brought the roadmap up to date with shipped features, including the JSON cell editor, column preferences, bring-your-own AI keys, the command palette, and Live mode - @husamql3
Sep 23, 2026
v1.14.1

A real JSON editor and a quicker row details sheet

πŸš€ Features

  • β€’ Replaced the JSON cell's plain textarea with a code editor: line numbers, syntax highlighting, folding, and inline errors that block saving invalid JSON - @husamql3

πŸ”§ Improvements

  • β€’ Row details now opens on a single click and the cell editor on a double click, with the sheet no longer dimming or blocking the grid behind it - @husamql3
  • β€’ Updated production dependencies: @tanstack/ai (0.54β†’0.55), @tanstack/ai-client (0.31.1β†’0.32.1), @tanstack/ai-gemini (0.29.4β†’0.30), @tanstack/ai-react (0.24.1β†’0.27), @tanstack/react-router (1.170.35β†’1.170.38), @tanstack/react-start (1.168.52β†’1.168.56), dotenv (17.4.2β†’18) - @husamql3

πŸ› Bug Fixes

  • β€’ Fixed saving an unedited JSON cell marking it as a pending change - @husamql3
  • β€’ Fixed the Save and Cancel buttons in the JSON cell editor doing nothing - @husamql3
  • β€’ Fixed Enter and Escape in the grid committing or discarding JSON cells other than the one being edited - @husamql3
  • β€’ Fixed a single click on a selected cell opening the cell editor and the row details sheet at the same time - @husamql3
  • β€’ Fixed the row details close button overlapping the row navigation arrows - @husamql3
Sep 21, 2026
v1.14.0

Live mode, row details, and a command palette

πŸš€ Features

  • β€’ Added Live mode for PostgreSQL: the table refreshes every second and highlights inserted rows and changed cells, pausing automatically while you edit - @marwan562, @husamql3
  • β€’ Added an editable row details sheet with keyboard navigation between rows and a confirmation before unsaved edits are discarded - @marwan562, @husamql3
  • β€’ Added a command palette for jumping to tables, running actions, and opening the assistant - @marwan562, @husamql3
  • β€’ Added per-table column preferences so you can hide and reorder columns, saved across sessions - @marwan562, @husamql3
  • β€’ Added table renaming across PostgreSQL, MySQL, SQL Server, SQLite, and MongoDB - @marwan562, @husamql3

πŸ”§ Improvements

  • β€’ Blurred the sticky table headers so rows stay legible as they scroll underneath - @marwan562, @husamql3
  • β€’ Enforced server coverage thresholds in CI - @marwan562

πŸ› Bug Fixes

  • β€’ Fixed PostgreSQL tables outside the public schema listing in the sidebar but failing to open, export, or show their columns - @husamql3
  • β€’ Fixed edits to a record with a composite primary key updating every row that shared the first key column - @husamql3
  • β€’ Fixed renaming a PostgreSQL table applying to a same-named table in another schema - @husamql3
  • β€’ Fixed editing a Redis key's name writing to the old key instead of renaming it - @husamql3
  • β€’ Fixed MongoDB record updates failing mid-write when the immutable _id field was edited - @husamql3
  • β€’ Fixed binary columns crashing the record editor when they already held a value - @husamql3
  • β€’ Fixed Edit Table navigation not returning to the data view - @marwan562
Sep 18, 2026
v1.13.1

CLI accuracy and safer startup errors

πŸ”§ Improvements

  • β€’ Refreshed TanStack, Vite, and Vitest, and tightened the build, typecheck, and task graph setup - @marwan562, @husamql3

πŸ› Bug Fixes

  • β€’ Fixed CLI help and status listing only MySQL and PostgreSQL instead of all six supported databases - @marwan562
  • β€’ Stopped startup errors from leaking connection URLs containing commas or parentheses, such as MongoDB replica set URIs - @husamql3
Sep 7, 2026
v1.13.0

Anonymous usage and reliability analytics

πŸš€ Features

  • β€’ Added opt-out anonymous analytics covering feature usage, database engine, performance, and sanitized errors, with a toggle in Settings β€” queries, schemas, names, and values are never collected - @husamql3

πŸ”§ Improvements

  • β€’ Replaced raw error console output with structured logs that record the operation and error type without leaking connection details - @husamql3
Sep 6, 2026
v1.12.0

Bring your own AI provider

πŸš€ Features

  • β€’ Added Gemini, OpenAI, Anthropic, Grok, and OpenRouter to the AI assistant, with a model picker and bring-your-own-key support - @Mahmoudgalalz
  • β€’ Added Generate with AI, Optimize with AI, and Suggest fix actions to the query runner - @Mahmoudgalalz
  • β€’ Added a Settings panel for the AI provider, key, and schema sharing, plus editor tab size, font size, and word wrap - @Mahmoudgalalz

πŸ”§ Improvements

  • β€’ Gave personal API keys their own rate-limit bucket and blocked forwarding them over plain HTTP - @husamql3
  • β€’ Kept the assistant working when a response stream fails or table metadata is only partly readable - @husamql3

πŸ› Bug Fixes

  • β€’ Fixed non-Gemini providers defaulting to a Gemini model, dropped query runner prompts, and stale indentation in the JSON cell editor - @husamql3
Sep 5, 2026
v1.11.0

Light mode and local development improvements

πŸš€ Features

  • β€’ Added Light, Dark, and System theme options with theme-aware colors across the application - @marwan562

πŸ”§ Improvements

  • β€’ Made number, date, boolean, and enum table cell controls transparent for consistent styling across light and dark themes - @husamql3
  • β€’ Removed the browser-native increment and decrement controls from numeric table cells - @husamql3
  • β€’ Made the pre-commit hook resolve Bun across macOS, Linux, and Windows and added type checking - @marwan562
  • β€’ Expanded the contributor guide with environment setup, Portless development, database initialization, and testing workflows - @marwan562

πŸ› Bug Fixes

  • β€’ Allowed local development origins and preserved custom Portless ports when connecting the web app to the API - @marwan562
Sep 4, 2026
v1.10.1

Fix scrolling in column type dropdowns

πŸ› Bug Fixes

  • β€’ Fixed column type dropdowns not scrolling with a mouse wheel or trackpad inside table, add-column, and edit-column overlays - @marwan562
Aug 28, 2026
v1.10.0

Support Redis key browsing

πŸš€ Features

  • β€’ Added Redis support with a dedicated key browser for strings, hashes, lists, sets, sorted sets, and streams, including a redis-cli style query runner - @husamql3
Aug 15, 2026
v1.9.7

Relicense to Apache 2.0

πŸ”§ Improvements

  • β€’ Relicensed DB Studio from BSL-1.1 to the Apache License 2.0
  • β€’ Fixed the release workflow failing when a merge to main doesn't bump the package version β€” npm publish is now skipped if the version is already published
Jul 7, 2026
v1.9.6

Fix SPA/API namespace collision and dependency updates

πŸ”§ Improvements

  • β€’ Updated production dependencies: @tanstack/ai (0.38β†’0.39.1), @tanstack/ai-gemini (0.18β†’0.19), @tanstack/react-router (1.170.16β†’1.170.17), @tanstack/react-start (1.168.26β†’1.168.27)
  • β€’ Updated dev dependencies: portless (0.13β†’0.15), vite (8.0.12β†’8.1.3), @vitejs/plugin-react (4β†’6)

πŸ› Bug Fixes

  • β€’ Fix browser refresh on client routes returning 400 β€” API now lives under /api prefix so the SPA owns the root namespace
Jul 2, 2026
v1.9.5

Fix npm package URLs in README

πŸ› Bug Fixes

  • β€’ Fixed the npm package URLs and license badge repository in the published README
Jul 2, 2026
v1.9.4

Dependency updates and README fix

πŸ”§ Improvements

  • β€’ Updated production dependencies: @tanstack/ai (0.16β†’0.38), @tanstack/ai-react (0.8β†’0.16), @tanstack/react-router (1.170.2β†’1.170.16), @tanstack/react-start (1.168.3β†’1.168.26), commander (14β†’15), three (0.184β†’0.185)
  • β€’ Updated dev dependencies (6 packages)

πŸ› Bug Fixes

  • β€’ Fixed license badge in README pointing to wrong repository
May 16, 2026
v1.9.3

Fix the database connection error

πŸš€ Features

  • β€’ Fix the database connection error - @husamql3
May 9, 2026
v1.9.1

Integrated PostHog analytics and Sentry error tracking

πŸš€ Features

  • β€’ Integrated PostHog analytics and Sentry error tracking for enhanced monitoring and error visibility - @husamql3
May 3, 2026
v1.9.0

Turn the current frontend package into a feature-first web app with extractable UI primitives, stable data/client boundaries, and a future desktop host path

πŸš€ Features

  • β€’ Turn the current frontend package into a feature-first web app with extractable UI primitives, stable data/client boundaries, and a future desktop host path - @husamql3
May 3, 2026
v1.8.0

Refactored database operation layer with new adapter-based architecture for better multi-database support

πŸš€ Features

  • β€’ Refactored database operation layer with new adapter-based architecture for better multi-database support - @husamql3
Apr 30, 2026
v1.7.12

Improved spacing in the table tab layout with enhanced bottom padding for better visual definition and separation

πŸš€ Features

  • β€’ Improved spacing in the table tab layout with enhanced bottom padding for better visual definition and separation - @MohmedAref31
Apr 28, 2026
v1.7.11

Add hover copy button for table cells to copy the cell value

πŸš€ Features

Apr 26, 2026
v1.7.10

Reorganized MongoDB database access layer into modular components for improved maintainability and clarity of database operations

πŸ”§ Improvements

  • β€’ Reorganized MongoDB database access layer into modular components for improved maintainability and clarity of database operations - @Youssef-joe
Apr 25, 2026
v1.7.9

Foreign key columns now support an interactive drawer to browse related table data

πŸš€ Features

  • β€’ New drawer component for improved data visualization - @husamql3

πŸ› Bug Fixes

  • β€’ Fix the rate limit logic in the chat sidebar - @amrable
  • β€’ Hide the drawer if there is no data to display - @Amirosagan
Apr 24, 2026
v1.7.5

Revive chat sidebar and align with local dev

πŸš€ Features

  • β€’ Revived chat sidebar and is now scoped to the selected database - @amrable

πŸ› Bug Fixes

  • β€’ Fix custom server port configuration not working - @husamql3
Apr 23, 2026
v1.7.4

Table sidebar now displays schema names for better organization

πŸš€ Features

  • β€’ Added schema dropdown to the table sidebar for better organization - @Amirosagan

πŸ”§ Improvements

  • β€’ Display database connection errors in frontend root route - @husamql3
Apr 12, 2026
v1.7.0

Support MSSQL and MongoDB databases

πŸš€ Features

  • β€’ Added Microsoft SQL Server (MSSQL) database support - @Amirosagan
  • β€’ Added MongoDB database support - @Youssef-joe

πŸ”§ Improvements

  • β€’ Improved API base URL detection to dynamically adapt to runtime environment, with fallback support for default configurations - @xaaksw

πŸ› Bug Fixes

  • β€’ Enhanced GitHub Actions workflows with concurrency controls to prevent overlapping automated pull request creation jobs - @xaaksw
  • β€’ Fixed table cell display to properly handle and render non-primitive object values - @husamql3
Apr 8, 2026
v1.5.1

Schema tab column editing

πŸš€ Features

  • β€’ Added schema tab column management with support for adding, editing, renaming, and dropping columns directly from the table structure view - @husamql3

πŸ”§ Improvements

  • β€’ Updated the table actions flow so the Edit table menu item opens the schema editor for the selected table - @husamql3
  • β€’ Added a report a bug button to the header to create a new GitHub issue - @husamql3
Mar 2, 2026
v1.4.0

Support MySQL database

πŸš€ Features

  • β€’ Added MySQL database support alongside PostgreSQL - @husamql3

πŸ› Bug Fixes

  • β€’ Improved database connection error detection and messaging - @husamql3
Feb 20, 2026
v1.3.33

Add table actions menu

πŸš€ Features

  • β€’ Add table menu with delete table feature (with support for foreign key constraints) and copy table schema feature, export table data feature (CSV, JSON, Excel) - @husamql3
  • β€’ Add bulk insert records feature by CSV, JSON, or Excel files in the table tab - @Youssef-joe

πŸ”§ Improvements

  • β€’ Improved error message for unsupported database types - @husamql3
  • β€’ Added the init-db script to initialize the database for local development - @Youssef-joe
  • β€’ Added confirmation dialog for delete record feature in the table tab - @husamql3
  • β€’ Added tooltip for the primary key and foreign key columns in the table tab - @husamql3
  • β€’ Added preset row count options to the table footer - @husamql3

πŸ› Bug Fixes

  • β€’ Improved database initialization and selection flow - @husamql3
  • β€’ Fix retriving the row count of the tables - @husamql3
Jan 27, 2026
v1.2.21

πŸš€ Features

  • β€’ Add delete column feature in the table tab - @husamql3
  • β€’ Add export table data to CSV or Excel files feature in the table tab - @Zeyad-F16

πŸ”§ Improvements

  • β€’ Used turbo to run and build the project - @husamql3
  • β€’ Implemented shared package to share code between the packages - @husamql3
Jan 13, 2026
v1.2.6

Implement the AI chat assistant

πŸš€ Features

  • β€’ Added AI chat assistant that helps users ask natural language questions about their data - @husamql3
  • β€’ Uses the user's database schema as context for more accurate and relevant responses; limited to 5 messages per day - @husamql3
Jan 11, 2026
v1.1.4

Support multiple databases from same host

πŸš€ Features

  • β€’ Allow users to add the database server link and switch between multiple databases on the same host - @Amirosagan

πŸ”§ Improvements

  • β€’ Improved date/time input handling and timestamp field UI for better accuracy - @saraanbih

πŸ› Bug Fixes

  • β€’ Fix the bug where displaying the Add Table sheet was not working - @husamql3
  • β€’ Fix the copy button in the landing page CodeBlockTabs component - @husamql3
Jan 7, 2026
v1.1.0

Implement the runner tab

πŸš€ Features

  • β€’ New SQL query runner with Monaco editor featuring PostgreSQL syntax highlighting, autocomplete, and code snippets - @husamql3
  • β€’ Query execution with results displayed in both table and JSON formats, including execution time and row count - @husamql3
  • β€’ Query management with save, favorite, and format features, plus keyboard shortcuts for quick access - @husamql3
Dec 29, 2025
v1.0.0

Initial Release