Conar

Conar, now published as Tamery, is a desktop database client that puts an AI assistant next to the query editor. It targets people who spend the day writing SQL against several engines and want help composing and optimizing queries without leaving the tool that runs them.

Connections are stored in the project's cloud with encrypted connection strings and optional password protection, on top of an open source codebase. PostgreSQL, MySQL, MSSQL and ClickHouse are supported today, with SQLite and MongoDB listed as coming.

The stack is TypeScript from end to end.

• Desktop shell: Electron with React, TypeScript, Vite, Tailwind CSS and shadcn/ui.
• Application layer: TanStack Start, Router, Query, Form and Virtual, with Arktype handling validation.
• Backend: Bun and Hono serving oRPC endpoints, with Drizzle ORM over PostgreSQL.
• Auth and AI: Better Auth for sessions, and the Vercel AI SDK with Anthropic models behind the SQL assistance.
• Model choice: the model driving the assistant can be swapped rather than fixed by the vendor.

Local development uses pnpm, with Postgres and Redis started through Docker Compose, Drizzle migrations to prepare the schema, and portless serving the API, app, main site and proxy over HTTPS on local domains. Unit and end-to-end test commands ship with the repository. Prebuilt downloads are offered for anyone who only wants to use it.