studio is a free, open source databases project written in TypeScript and released under AGPL-3.0. It has 5,975 GitHub stars, 265 forks and 89 open issues, and was last pushed 6 months ago. On this registry it ranks #127 of 203 tracked projects in Databases, with 5 head-to-head comparisons available.

What is studio?

Outerbase Studio is a lightweight, browser-based GUI for managing SQL databases, built for developers and teams who want to query, edit data, and adjust schema across SQLite-family engines, MySQL, and PostgreSQL without installing a traditional desktop client.

What it is

Outerbase Studio is an open-source, TypeScript-built database client that runs in the browser. It began as a GUI for LibSQL and SQLite and has since widened its scope to a broad set of engines: Turso/LibSQL, SQLite local files, Cloudflare D1, rqlite, StarbaseDB, and Val.town, with MySQL and PostgreSQL support described as beta with limited features. It lives in the SQL tooling ecosystem alongside the runtimes it targets, and it is distributed under the AGPL-3.0 licence. The project is published by Outerbase, has accumulated roughly 5,975 stars and 265 forks on GitHub, and carries a hosted instance on its own domain.

The concrete problem it solves is the friction of inspecting and modifying a database without a heavyweight or paid client. It replaces the desktop SQL client for teams whose databases sit in serverless or edge environments, and it replaces writing raw DDL whenever a column needs to be added or dropped. Because connections can be stored in the browser or on a server, the same set of connections can follow a developer between machines rather than being trapped in one laptop's local configuration.

Key capabilities

  • A query editor with auto-completion and function hint tooltips that can run multiple queries at once and display each result set.
  • A data editor that stages changes and shows a preview before commit, optimized to render thousands of rows and columns.
  • A schema editor for creating, modifying, and removing table columns through the interface, without writing SQL.
  • A connection manager that stores connections locally in the browser, or on a server so they can be shared across devices.
  • A "Deploy to Cloudflare" button in the README that provisions the app through Cloudflare Workers.
  • Desktop builds for Windows and Mac, distributed from the outerbase/studio-desktop releases page as a lightweight Electron wrapper around the web version.
  • Direct database coverage spanning LibSQL, SQLite, Cloudflare D1, rqlite, StarbaseDB, Val.town, MySQL, and PostgreSQL.

Who uses it and how

  • Developers working with edge and serverless databases such as Cloudflare D1, Turso/LibSQL, rqlite, StarbaseDB, and Val.town, who need a GUI where no native desktop driver exists.
  • Teams that want shared connection definitions held on a server instead of duplicated per developer machine.
  • Anyone evaluating the tool before committing: a hosted playground at libsqlstudio.com/playground/client?template=chinook runs against the Chinook sample schema.
  • Desktop users on Windows or Mac who need MySQL and PostgreSQL drivers that cannot run inside a browser sandbox.
  • Individuals who want to browse or edit a local SQLite file without installing a full database IDE.

Getting started

The quickest route is the hosted instance at https://libsqlstudio.com, or the "Deploy to Cloudflare" button in the README, which deploys the app to Cloudflare Workers. Windows and Mac users who need MySQL or PostgreSQL support should download the desktop build from the outerbase/studio-desktop releases page.

How it compares

No competing products are named in the facts provided, and no list of paid products this project replaces was supplied, so on the evidence available Outerbase Studio stands alone in this registry. Its position is defined relative to the databases it connects to rather than to other GUI clients.

When to use it — and when not to

Choose it when the database is LibSQL, SQLite, Cloudflare D1, rqlite, StarbaseDB, or Val.town and a browser or Electron client is acceptable; the connection manager and deploy button make it easy to share and host. Avoid relying on it for production MySQL or PostgreSQL work, since both are marked beta with limited features and require the desktop Electron wrapper, and note that the README covers features far more thoroughly than setup or self-hosting. The AGPL-3.0 licence and the 89 open issues are also worth reviewing before adopting it inside a closed product.

project readme (upstream, from github) — read inline

Outerbase Studio

Deploy to Cloudflare

Outerbase Studio is a lightweight, browser-based GUI for managing SQL databases, designed for simplicity and versatility. Initially built for LibSQL and SQLite, it now supports a broad range of databases, including:

Supported Databases:

  • SQLite-based Database
    • Turso/LibSQL
    • SQLite (local files)
    • Cloudflare D1
    • rqlite
    • StarbaseDB
    • Val.town
  • MySQL (beta, limited features)
  • PostgreSQL (beta, limited features)

Give it a try directly from your browser

LibSQL Studio, sqlite online editor Libsql studio playground

Desktop App

You can download Windows and Mac desktop app here.

Outerbase Studio Desktop is a lightweight Electron wrapper for the Outerbase Studio web version. It enables support for drivers that aren't feasible in a browser environment, such as MySQL and PostgreSQL.

Features

libsqlstudio-git-preview (7)

  • Query Editor: It features a user-friendly query editor equipped with auto-completion and function hint tooltips. It allows you to execute multiple queries simultaneously and view their results efficiently.
  • Data Editor: It comes with a powerful data editor, allowing you to stage all your changes and preview them before committing. The data table is highly optimized and lightweight, capable of rendering thousands of rows and columns efficiently.
  • Schema Editor: It allows you to quickly create, modify, and remove table columns with just a few clicks without writing any SQL.
  • Connection Manager: It includes a flexible connection manager, allowing you to store your connections locally in your browser. You can also store them on a server and share your connections across multiple devices.

The features mentioned above are just a few of the many we offer. Give it a try to explore everything we have in store

Frequently asked questions

Is studio free to use?

studio is open source under the AGPL-3.0 licence. There is no licence fee and no seat count — you can self-host it or, where the project offers one, pay a vendor for a managed version instead.

What does studio do?

A lightweight Database GUI in your browser. It supports connecting to Postgres, MySQL, and SQLite.

What is studio written in?

studio is primarily written in TypeScript. Its source is publicly available at https://github.com/outerbase/studio, and it has 5,975 GitHub stars.