Lightweight cross-platform database client for 100+ databases, with desktop, Docker, CLI, a built-in AI SQL assistant and an MCP server.
- Stars
- 1,452
- Forks
- 106
- Open issues
- 25
- Last commit
- yesterday
What is it?
Tamery is a database client for browsing tables, editing data, writing SQL and visualizing schemas. It connects to PostgreSQL, MySQL, MariaDB, SQL Server, ClickHouse and SQLite, and also Turso and Cloudflare D1. Connections can be set up by pasting a connection string, an .env file, a JDBC URL or a psql command.
An AI assistant helps write, explain and fix SQL, and it asks before changing any data. The project also includes an MCP server so agents such as Claude Code and Cursor can query connected databases, with every write waiting for user confirmation. Connections sync across devices and can be stored without passwords, and SSH tunnels and SSL are supported.
The desktop app is the main way to use it and can reach localhost and private networks. The web version is also available. The code is open source under AGPL-3.0, and the project is built with TypeScript, pnpm and Bun.
Key features
- 01Browse, sort, filter and edit table data inline.
- 02Query editor with autocomplete based on your schema.
- 03AI assistant that writes, explains and fixes SQL, asking before data changes.
- 04MCP server that lets agents query connected databases.
- 05Schema visualizer.
- 06Connections synced across devices, with SSH tunnels and SSL support.
Use cases
- Exploring and editing data across PostgreSQL, MySQL or SQLite databases from one client.
- Letting Claude Code or Cursor query a development database with write operations gated by confirmation.
- Quickly connecting to a database by pasting a connection string or psql command.
Quick start
- 1
Install the desktop app on macOS with Homebrew
brew install --cask tamery - 2
Install the desktop app on Arch Linux
yay -S tamery-bin - 3
Clone the repo and install dependencies with pnpm
pnpm install - 4
Start the Docker services, run migrations, then start the dev server
pnpm run docker:start && pnpm run drizzle:migrate && pnpm run dev
Things to know
- Self-hosting requires pnpm, Bun, and Postgres plus Redis or Docker.
- Pull requests are not accepted, so outside code contributions are not possible.
- The full AI assistant requires a Pro subscription.
Topics
FAQ
- What is tamery?
- AI-powered database client and MCP server for desktop and web, supporting Postgres, MySQL, MariaDB, SQL Server, ClickHouse and SQLite. Tamery is a database client for browsing tables, editing data, writing SQL and visualizing schemas. It connects to PostgreSQL, MySQL, MariaDB, SQL Server, ClickHouse and SQLite, and also Turso and Cloudflare D1. Connections can be set up by pasting a connection string, an .env file, a JDBC URL or a psql command.
- Is tamery free to use? What license does it have?
- tamery is open source under the AGPL-3.0 license. Check the license terms before using it in commercial products.
- Is tamery still maintained?
- Actively maintained. The last commit to tamery was on Oct 19, 2026.
- What can I use tamery for?
- Exploring and editing data across PostgreSQL, MySQL or SQLite databases from one client. Letting Claude Code or Cursor query a development database with write operations gated by confirmation. Quickly connecting to a database by pasting a connection string or psql command.
- How do I install tamery?
- Install the desktop app on macOS with Homebrew: brew install --cask tamery Install the desktop app on Arch Linux: yay -S tamery-bin Clone the repo and install dependencies with pnpm: pnpm install Start the Docker services, run migrations, then start the dev server: pnpm run docker:start && pnpm run drizzle:migrate && pnpm run dev
- Where can I get tamery?
- The source code and installation instructions are on GitHub: https://github.com/wannabespace/tamery
Summary generated by AI from the project's README. GitHub stats refresh daily.
Related projects
A free, local-first, AI-assisted database client and SQL workspace supporting 40+ databases across desktop, web, Docker and CLI.
A minimal, token-efficient MCP server that lets AI clients query and explore PostgreSQL, MySQL, SQL Server, Oracle, MariaDB and SQLite databases.
Native database IDE for macOS, Windows and Linux supporting PostgreSQL, MySQL, SQLite, Redis, MongoDB, SQL Server and ClickHouse, with a built-in MCP server and AI chat.
Free multi-platform desktop SQL client and database tool supporting 100+ databases via JDBC and ODBC drivers.
A keyboard-driven terminal UI for connecting to and querying many SQL databases, inspired by lazygit.