Skip to content

Fosta Studio 0.2.0

Choose a tag to compare

@github-actions github-actions released this 09 Nov 14:14

Added

  • Workspace Commands: startup tasks become the workspace's Commands (panel, and a toolbar menu to start, stop, restart or
    open the log of each). A command starts with the workspace or when a connection needs it, and a connection can be bound to one
    (Edit connection → Command, or New command… with a kubectl port-forward template): connect starts it if needed and waits
    until it is ready. Connections share a command; one started for them stops with the last of them. Failures show
    COMMAND_FAILED with the log tail; the log opens from the connection's menu.
  • MCP server: Claude Code, Claude Desktop, Cursor, VS Code and Zed can use saved connections without seeing passwords
    (Settings → MCP server, off by default). Streamable HTTP on 127.0.0.1 with a bearer token kept in Credential Manager, a stdio
    bridge (fosta-studio mcp, fosta-studio-server mcp), and /mcp on the web edition behind its access token. Each workspace
    opts in (MCP clients: Off / Read-only / Ask before writes; Production and Read-only workspaces at most Read-only). Tools:
    list_connections, list_databases, list_tables, describe_table, schema_overview, run_read_query and run_query, which
    the user approves statement by statement in a dialog naming the client. Every call is audited; see docs/mcp.md.
  • Updates: a daily check for a new release (Settings → Check for updates, on by default; Check for updates now any time) and
    an Update X.Y.Z item in the status bar. The installed Windows app downloads the update in the background and installs it on
    quit or with Restart to update, asking first about open transactions and unsaved edits, then shows what's new once. The
    portable app links to the release; the web edition shows the Docker commands, and deploy/docker-compose.yml has an optional
    Watchtower service (--profile autoupdate).
  • Vector tools (columns, indexes, similarity search, health checks and index recall) on more engines, in addition to MariaDB
    from 0.1.0:
    • PostgreSQL (pgvector): vector and halfvec columns, HNSW and IVFFlat indexes with their metric, search by cosine, L2 or
      inner product, when the extension is installed in the database. The dev and CI image is now pgvector/pgvector.
    • Oracle 23ai: VECTOR columns, IVF and HNSW indexes, VECTOR_DISTANCE search.
    • Elasticsearch and OpenSearch.
    • Redis 8: search indexes with VECTOR fields (FLAT or HNSW), KNN search.
    • ClickHouse: Array(Float32) columns and vector_similarity indexes.
  • Tabs come back after a restart: each workspace's open tabs (tables, query tabs with their text, language and database,
    diagrams, command logs) and the active tab are saved in fosta-studio-tabs.json next to the config (the data volume on the web) and
    restored on start. A restored tab connects only when it is shown; a tab whose connection is gone is dropped with a note. A file
    that cannot be read is never overwritten; one that does not parse is moved to fosta-studio-tabs.json.corrupt. Two windows of the
    web edition merge their tabs instead of overwriting each other's (a tab closed in one window but open in the other comes back).
  • Unsaved query text: closing a query tab whose text was edited and not run asks first, and quitting lists those tabs (once:
    restored text left unchanged is not listed again). Close all, and deleting a workspace or a connection, ask one question for
    all tabs that would lose something; declining keeps the workspace or connection.
  • Query results: click a column header (or use its menu) to sort the loaded rows (numbers and decimals exactly, timestamps by
    instant); Refresh names reloads the completion names.
  • New logo (an F made of data rows) in the app icon, welcome screen, web favicon, website and README, and engine logos for
    PostgreSQL, SQLite, ClickHouse, Oracle, Redis, Elasticsearch and OpenSearch.
  • Hide the sidebar with Ctrl+B or its button, and hide the workspace rail with its small arrow (Ctrl+Shift+B).
  • Production hint: saving a connection whose name, host, database or URL says prod, production, prd or live, outside a Production
    workspace, offers to move it there (read-only by default).
  • Trust: a security and privacy page (docs/security.md), SECURITY.md with how to report a
    vulnerability, issue templates (bug report, feature request), and CI audits of Rust and npm dependencies.

Changed

  • Performance:
    • MariaDB/MySQL query tabs stop a read at the row cap instead of reading the rest (SELECT * on 1M rows: 3.4 s → 0.14 s).
    • Paging quickly no longer exhausts the connection pool: a replaced or closed page read is cancelled on the server (KILL
      QUERY, PostgreSQL cancel); a busy MariaDB/MySQL pool says so instead of asking whether the server is reachable; page reads
      stop after 120 s when the rules set no timeout.
    • The last page reads from the end (reversed order, no deep OFFSET) and counts exactly, so it is right on tables larger than
      their statistics and fast when sorted.
    • CSV and JSON export of every row streams to the file (desktop) or the browser's download (web) instead of building it in the
      page; the files are unchanged (except integers beyond 2^53, now exact in JSON).
    • PostgreSQL scripts run in about one round trip per statement (a 3,750-statement script: 22.8 s → 4.5 s).

Fixed

  • Menus no longer end partly outside the window (they were measured during their opening animation) and scroll when taller
    than the window; the arrow keys move through them.
  • Scripts with many statements: the result tabs update incrementally, and above 50 result sets one list of them replaces the
    tabs (click one to open it), so a 15,000-statement script no longer freezes the window.
  • Stop in a query tab shows Stopped with the rows received so far instead of an error.
  • Tab titles name the connection, and the database, when two tabs share a title.
  • Lost sessions: after the backend or the server restarted, a query tab reconnects and reopens its session on the next run, and
    the tree no longer shows a connection the backend lost as connected. The run goes again on its own only when every statement
    reads; otherwise (and when an open transaction was lost) nothing runs and the tab says the session was reset, since settings such
    as SET ROLE, search_path and temporary tables are gone.
  • Completion names reload after a tree Refresh and after DDL runs in the tab; a new query tab on SQLite starts in main.
  • Vector index recall: a row as close as the exact k-th result now counts as a hit, so tables with duplicate vectors no longer
    report a recall near 0.
  • Oracle in the web edition: the Docker image now includes libaio, and the server puts its Instant Client download folder on
    LD_LIBRARY_PATH at start, so the client downloaded from the connection dialog loads without a restart. On other Linux hosts the
    load error names the folder to put on LD_LIBRARY_PATH.
  • Redis key tree: a page now ends where a SCAN call ends, so no key is skipped while the server rehashes.
  • SQL Server on Linux and in the web edition: an untrusted certificate shows the same "Accept invalid certificates" hint as on
    Windows.

Security

  • SQLite: the bundled SQLite library is updated (libsqlite3-sys 0.39, rusqlite 0.41) for CVE-2026-119375
    (RUSTSEC-2026-0459), reachable through a crafted database file.
  • MariaDB/MySQL: a page read cancelled just as it finished no longer leaves a KILL QUERY behind for the next statement on
    that pooled connection (another tab's page or grid save failed with "Query execution was interrupted").
  • Data files: the open tabs file, the configuration, the query history and the audit log are written readable by their owner
    only (mode 0600 on Linux, the web edition's volume); files from earlier versions are restricted on the next start.
  • CSV exports: a cell that a spreadsheet would run as a formula (starting with =, +, -, @, a tab or a carriage return) is
    written with a leading single quote and quoted, in the page exporters and the streamed export alike; plain numbers such as
    -5 are unchanged.
  • Web edition: wrong MCP tokens at /mcp are limited per client in a bucket of their own, so an MCP client with a stale token
    can no longer lock every browser out of sign-in for 15 minutes.

Docker (web edition)

docker run -d --name fosta-studio -p 127.0.0.1:8080:8080 -v fosta-studio-data:/data ghcr.io/caothanhphatit/fosta-studio:0.2.0
docker logs fosta-studio

Open the sign-in address printed in the log. Image: ghcr.io/caothanhphatit/fosta-studio; settings in docs/web-edition.md.