We are happy to release v0.10.2 with a lot of improvements

More Drivers

We have added several new drivers:

• Cloudflare Durable Object
• Cloudflare Worker Analytics Engine

Integrated AI

We've integrated AI into your query editor to help you write and improve queries. You can also choose from different AI models, all powered by Cloudflare Workers AI.

Design Dashboard

We now support custom dashboards, allowing you to add charts from multiple data sources.

Other Features

• Add create and edit table support by @sokphaladam in #366
• Allow user to export the whole table by @lurenjiamax in #415

Design Improvement

You may noticed there are several design improvement and changed. Thanks to @loganliffick and @Brayden

Outerbase Cloud

We've added Outerbase Cloud integration, enabling existing Outerbase Cloud customers to harness the power of our open-source studio.

Bugfixes:

• Fixed unable save edit column after discard change by @roth-dev
• Fixed fail to parse foreign key when there is default value in SQLite
• Fixed diagram does not follow color theme @JoschuaSchneider
• Fixed postgres auto completee using backtick instead of double quot
• Fixed studio complain about requires HTTPS when running on HTTP protocol
• Fixed ERD column overflow with long data type by @sokphaladam

We moved to Cloudflare Page

Our project now can also be deployed to Cloudflare page. Actually, our studio has moved from Vercel to Cloudflare page.

Update

• We upgrade to NextJS 15
• We upgrade to Tailwind 4

New Contributors

• @loganliffick made their first contribution in #328
• @JoschuaSchneider made their first contribution in #394
• @lurenjiamax made their first contribution in #415

Full Changelog: v0.9.2...v0.10.2

What's Changed

• Support running query with variables.
• Integration saved query for our desktop wrapper
• Fix: Only 'https' and 'http' should be considered as links; otherwise, it should be treated as a text cell.

What's Changed

• Ability to create and edit view
• Tab now is scrollable. It is good for those who work with a lot of tabs.

This major release focuses on restructuring the codebase to enable an extension-based architecture and addressing technical debt. While new features are limited, several improvements and fixes are included to enhance the user experience.

What’s New?

• Upgraded Framework: Migrated from Next.js 14 to Next.js 15 for improved performance and compatibility.
• SQLite Online Viewer Updates:
  • Added support for browsers that do not support the FileSystemHandler API, with a fallback to traditional file input.
  • Redesigned interface for better usability.
• Database Indicator: Introduced a small color marker on the left side of the database list to help identify the active database.

Bug Fixes and Improvements

• Resolved incorrect ERD layout when no relationships exist.
• Implemented throttling for error logs to reduce noise and improve clarity.

Thank you for using Outerbase Studio! Feedback and contributions are always welcome.

Adding Dolt Integrated Support

[Download Desktop App Here]

Dolt is a version-controlled SQL database, enabling collaboration, branching, and merging of data like Git for databases. Outerbase Studio now support limited functionality for working with Dolt.

• Commit and view commit history
• Staged/unstaged changes
• Switch branch
• Create new branch
• Reset from commit

We will continue to add more support for Dolt. Let us know which feature you want us to implement for Dolt.

• Adding the row count
• Multiple cell selection
• Improve the EXPLAIN for MySQL and Sqlite
• Add and edit trigger
• Massive improve on export. Support CSV, Excel, Delimited Text, JSON and SQL.
• MySQL Sandbox Playground from your browser

Multiple Cell Selection

Outerbase Studio now support multiple cell selection. This will open door for more flexiblity.

Now you can get the aggregate value of the selected cells.

More Export Options

We now support more export option

Full Changelog: v0.8.1...v0.8.2

What's Changed

Table Size

We now display the disk size of tables for both MySQL and PostgreSQL, enabling users to quickly identify which tables consume the most storage space.

Better Explain Visual for MySQL

We’ve introduced an improved EXPLAIN Visualizer. While it’s still in early development and doesn’t cover all cases yet, it provides a solid starting point.

We have been gradually releasing new features, but it's been a while since we last published a changelog. Here’s the changelog covering the updates from the 0.7.1 to v0.8.0.

Entity Relationship Diagram (ERD) support

You now can generate a beautiful Entity Relationship Diagram. Currently only work great with Sqlite-based database and MySQL.

Number of Rows and Column

Show the number of rows and columns on the query result tab.

Column Type Suggestion for MySQL

We provide a great support for column type selection when create or edit table column.

Other Changes

• Mass drop table
• Add Starbasedb (yet another Sqlite-based database)
• Add "USE" statement support for MySQL
• Export to Excel file

Adding MySQL Support

We’ve added support for MySQL! You can now connect to MySQL using our desktop app (https://github.com/outerbase/studio-desktop/releases/tag/v0.1.15). Please note that MySQL support is still in its early stages, and it will be our primary focus for future sequential releases.

Adding PostgreSQL

We also support PostgreSQL, though it’s still in its early stages. While functional, it’s not yet fully refined.

Quality of life improvement

• We will fallback to rowid if there is no primary key
• Generate column cannot be edit
• Add duplicate rows
• Add commit and discard keybinding

What's Changed

• [Major Feature] Add MySQL support
• Support ATTACH (this can be used via command line)
• Add small gutter highlight on statement user currently on
• LibSQL Studio now provides more customization for embed iframe
  • Override the theme color
  • Option to disable the light/dark more toggle button

Thanks to @rentalhost for various of improving:

• Added support for closing tabs with the middle mouse button
• Added a type mismatch indicator
• Use green color for texts
• Added ellipsis for large numbers, texts, and links
• Prevent visual glitch when entering field edit mode

We also have also redesign LibSQL Studio website.