Conar.app

Conar is an AI-powered open-source project that simplifies database interactions. Built for PostgreSQL, with support for other databases coming in the near future. Store your connections securely in our cloud and ask AI to help you write and optimize SQL queries.

Features

• 🔐 Secure & Open

  • Open-source codebase
  • Encrypted connection strings
  • Password protection

• 💾 Multi-Database Support

  • PostgreSQL
  • MySQL (coming soon)
  • MongoDB (coming soon)

• 🤖 AI-Powered Features

  • Intelligent SQL assistance
  • Ability to change AI model
  • More coming soon..

Stack

• React with TypeScript
• Electron
• TailwindCSS and shadcn/ui
• Vite
• TanStack Start/Router/Query/Form/Virtual
• Arktype
• Bun
• Hono
• oRPC
• Drizzle ORM
• Better Auth
• AI SDK with Anthropic, OpenAI, Gemini and XAI
• Supabase
• Railway
• PostHog
• Loops

Development Setup

• 📦 Package Installation

  pnpm install

• 🐳 Start Database with Docker Compose

  This will start the PostgreSQL database & Redis in the background.

  pnpm run docker:start

• 🗄️ Prepare Database

  This will run database migrations to set up the required tables and schema.

  pnpm run drizzle:migrate

• 🚀 Run the Project

  This will start all development servers using Turbo.

  pnpm run dev

Testing

• Unit Tests

  pnpm run test:unit

Before running E2E tests, make sure to start the test server: pnpm run test:start and db postgresql://postgres:postgres@localhost:5432/conar

• E2E Tests

  pnpm run test:e2e

License

This project is licensed under the Apache-2.0 License — see the LICENSE file for details.

_{Built with ❤️}