Free & open source Windows · about 10 MB · GPL-3.0
A small, fast database client for MariaDB, MySQL, SQL Server and MongoDB, with workspaces that bring their own tunnels and an AI assistant that writes queries but never runs them.
Release builds are coming soon. Until then, build it from source.
Illustration of the app's layout. Screenshots will follow with the first release.
Why Fosta Studio
Built for developers who hop between projects, customers and environments all day, on a machine that has better things to do with its memory.
A Tauri 2 app with a Rust core and a plain TypeScript UI. The release executable is about 10 MB, portable, with no installer required.
No UI framework, a virtualised grid and native drivers. It uses far less memory than clients built on Electron or Java.
GPL-3.0, no account, no telemetry. Read the code, build it yourself, and send a pull request when something bugs you.
Bring your own model. The assistant reads schema metadata and writes queries, but it has no tool that runs them. You do.
Features
Group connections, startup tasks and open tabs per project, customer or environment, then switch from the rail on the left or with Ctrl+1…9. Tabs of other workspaces stay open.
kubectl port-forward or any command when a workspace opensA virtualised grid that pages through large tables, with type badges under each column name so you always know what you are looking at.
WHERE filters and per-column filters, sortingSee how a database fits together. The diagram lays itself out automatically; drag tables around, zoom in, and export the result.
Ask in plain words. The assistant reads table and column metadata, writes the query, and can open a diagram, a table or a new query tab for you. Every code block has Insert and New tab buttons.
It has no tool that runs queries or changes data. You read what it wrote, and you decide whether to run it.
Disclosure: Fosta, the default provider, is a separate AI API service run by the author of Fosta Studio. It is listed first for convenience only; nothing in Fosta Studio requires a Fosta account, and requests only go to the provider you configure.
Import CSV, TSV or JSON with column mapping. Export to CSV, CSV for Excel, JSON, SQL INSERT statements or Markdown.
For MariaDB 11.7+: embedding search, column and index health checks, and recall of the vector index measured against exact search.
Paste a connection string for any engine, including MongoDB Atlas URIs. A password inside it is moved to Credential Manager.
Syntax highlighting, table-name completion, several statements per run, and one session per tab so BEGIN…COMMIT can span runs.
Engines
Each engine is a native Rust driver behind one shared interface, so the grid, diagram and assistant work the same everywhere.
Including vector tools on 11.7+
Stop a running query from the editor
Schemas, TLS on by default
JSON filters, Atlas URIs, inferred diagram links
On the roadmap
On the roadmap
Privacy & safety
Fosta Studio talks to your databases and to the AI provider you configure. Nothing else.
Workspaces, connections and tasks live in fosta-studio.json next to the executable. No secrets are written to it.
Database passwords and AI keys are stored in the operating system's credential store, never in the config file.
The app does not phone home and does not need a sign-up. It is fully usable offline with local databases.
The model sees table and column metadata plus the editor text, errors and logs you choose to share. It reads no rows and cannot run statements.
Every statement will pass through one gateway with rules per workspace: Open, Guarded, Read-only or Custom. A workspace marked Production defaults to Read-only, and relaxing a rule always comes with a loud warning.
Roadmap
Planned work, roughly in order. Plans change; open an issue to discuss any of it.
Rules per workspace, auto-commit switch, Begin / Commit / Rollback, open-transaction warnings.
Column statistics and histograms; rule-based test data with preview before insert.
Logical dumps built by the app, no external tools required.
A query bar with autocomplete, document views and an aggregation builder.
Create and run development servers without Docker or admin rights.
A Docker image to use Fosta Studio in a browser, and end-to-end encrypted sync between machines.
Open source
Fosta Studio is licensed under the GNU General Public License v3.0. Use it, study it, change it and share it.
Contributions are welcome. On your first pull request you are asked to sign the Contributor License Agreement: you keep the copyright in your work, and the maintainer may also offer commercial licenses while the project itself stays GPL.
Release builds are coming. Meanwhile you can build the portable executable yourself with Node 20+, Rust 1.88+ and the MSVC or GNU toolchain (toolchain details).
> git clone https://github.com/caothanhphatit/fosta-dbclient.git
> cd fosta-dbclient
> npm install
> npm run tauri build -- --no-bundleThe result is src-tauri\target\release\fosta-studio.exe. Want to try the UI first? npm run dev previews it in a browser with sample data.