Conar

Conar is an open-source web app and server that provides a graphical interface for database management. It allows users to interact with multiple database types and manage connections through a web application and server architecture. The software is designed for developers and database administrators who need to write and optimize SQL queries across different environments.

This tool is deployed as a server-based application and utilizes a cloud sync system to store connection strings securely. It focuses on simplifying the interaction between the user and the database by providing a centralized hub for query execution and schema management. By combining a traditional GUI with AI capabilities, it targets users who want to reduce the manual effort involved in writing complex SQL statements.

Key features

• Support for PostgreSQL, MySQL, MSSQL, and Clickhouse databases
• AI-powered assistance for writing and optimizing SQL queries
• Ability to switch between different AI models
• Encrypted storage for database connection strings
• Password protection for secure access
• Open-source codebase for transparency and auditing
• Integration with multiple AI providers including Anthropic, OpenAI, Gemini, and XAI

Built with a modern stack including React, TypeScript, and Electron, Conar integrates several AI SDKs to provide its natural language capabilities. The backend utilizes Hono and Drizzle ORM to handle data operations, while the frontend is constructed with TailwindCSS and shadcn/ui. The architecture is designed to handle multiple database connections simultaneously while maintaining security through encrypted strings. The development environment is managed via pnpm and Docker Compose, ensuring that the necessary services and database migrations are handled consistently across different installations.

Conar is a modern database client that combines traditional GUI management with generative AI to reduce the complexity of SQL authoring for technical teams.