AloDB

AI-powered database assistant that helps users interact with PostgreSQL databases using natural language.

Quick Start

# Setup
cp app.env.example app.env
# Edit app.env with SERVER_PORT

# Run
make run

Usage

AloDB uses WebSocket for real-time streaming with client-side query execution - your database credentials never leave your machine.

# Get available models
curl http://localhost:8080/v1/models

# Connect via WebSocket (use wscat, websocat, or your app)
wscat -c 'ws://localhost:8080/v1/agent/stream?api_key=your-gemini-key'

# Then send chat messages:
# {"type": "chat", "payload": {"message": "Show me all users"}}

See WebSocket API docs for the full protocol.

Documentation

Doc	Description
API	WebSocket API, endpoints, examples
Agent	LLM agent, tools, prompt engineering
Development	Setup, building, contributing

Tech Stack

• Go 1.21+ with Google ADK
• Gemini LLM (API key via request header)
• PostgreSQL support
• Domain-Driven Design architecture

Commands

Command	Description
make run	Run the server
make build	Build binary
make test	Run tests
make tidy	Install dependencies