Awesome ClickHouse › GUI

wannabespace/tamery

⭐ 1469 TypeScript added to this list on 2026-10-19 repository created 2024-11-27

Tamery is a cross-platform database client, shipped as both a desktop app and a web app, supporting PostgreSQL, MySQL, MariaDB, SQL Server, ClickHouse, SQLite, and hosted services such as Turso and Cloudflare D1. It favors being fast and simple over exposing every possible feature: opening a connection accepts a raw connection string, an .env file, a JDBC URL, or a psql command, and the app infers the rest. Once connected, it provides a table browser for sorting, filtering and editing data in the grid, a query editor with schema-aware autocomplete, and a schema visualizer. An integrated AI assistant writes, explains and fixes SQL, but by design any write that would change or delete data pauses for explicit user confirmation before it runs. Tamery also ships an MCP server, so agent tools such as Claude Code or Cursor can query a connected database, with every write still gated behind a manual click. Connections can be saved and synced across devices, with or without stored passwords, and support SSH tunnels and SSL; a metadata-only mode keeps connection strings encrypted locally so they never leave the machine. The desktop build works offline and connects to localhost and private networks without extra setup; the web app mirrors the same features for remote use. Core browsing and editing is free, while a paid tier adds the full AI assistant. The project is open source, though its maintainers write the code themselves and do not accept external pull requests, while still reading and acting on filed issues. For ClickHouse users, Tamery is a lightweight alternative to heavier database IDEs when the main need is browsing tables, running ad hoc queries, and getting AI help writing SQL.

https://github.com/wannabespace/tamery

database-clientguimcpai-assistantsql-editor