Launching today
Fosta Studio
Fast, open-source database client for 11 databases
2 followers
Fast, open-source database client for 11 databases
2 followers
Fosta Studio is a free, open-source database client built in Rust. An AI agent that knows your schema, MCP for Claude Code and Cursor, a workspace per project with its own safety rules, and SSH tunnels that start on connect. 11 databases, 9 MB.
Fosta Studio is a free, open-source database client for the databases teams actually run: MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Oracle, MongoDB, Redis, Elasticsearch, OpenSearch and ClickHouse. It is a native Rust app with a 9 MB Windows installer, plus a web edition that runs with one docker run (macOS and Linux included).
What you get:
Workspaces for each client or environment, each with its own connections, SSH tunnels and port-forward commands that start when you connect.
Safety rules per workspace. Production is read-only by default, risky statements (DROP, TRUNCATE, UPDATE without WHERE) ask first, and the database itself enforces read-only, not just the app.
An editable data grid with typed filters, keyset paging that stays fast on millions of rows, and streamed CSV/JSON export.
A query editor with completion that knows your schema, multi-statement runs, result sorting, and tabs that come back after a restart.
Engine-specific views: a Mongo query bar and aggregation, a Redis key browser and console, Elasticsearch Dev Tools with ES|QL, ClickHouse parts and the query log, Oracle PL/SQL, and ER diagrams.
Vector tools for search, health checks and recall on MariaDB, PostgreSQL (pgvector), Oracle 23ai, Elasticsearch/OpenSearch, Redis 8 and ClickHouse.
A built-in AI assistant using your own provider and key (OpenAI, Anthropic, Gemini, Ollama and more), plus an MCP server so agents like Claude Code or Cursor can use your connections. It is off by default, read-only or ask-before-write per workspace, and every call is audited.
Private by design: no account, no telemetry. Passwords stay in the Windows Credential Manager, or in an encrypted store in the web edition. GPL-3.0 licensed.