conar

conar

AI-powered tool for working with Postgres. (beta)

Stars: 615

Visit
 screenshot

Conar is an AI-powered open-source project designed to simplify database interactions. It is built for PostgreSQL with plans to support other databases in the future. Users can securely store their connections in the cloud and leverage AI assistance to write and optimize SQL queries. The project emphasizes security, multi-database support, and AI-powered features to enhance the database management experience. Conar is developed using React with TypeScript, Electron, and various other technologies to provide a comprehensive solution for database management.

README:

Conar Logo Conar.app

image

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.

Download Conar

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 in the background.

    docker-compose -f docker-compose.dev.yml up -d
  • 🗄️ 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

License

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

Built with ❤️

For Tasks:

Click tags to check more tools for each tasks

For Jobs:

Alternative AI tools for conar

Similar Open Source Tools

For similar tasks

For similar jobs