Skip to content

Ablasko32/VibeDB-Text2SQL

Repository files navigation

VibeDB

Next JS TypeScript TailwindCSS Postgres

Video Demo

Watch Demo

What is VibeDB?

VibeDB is a fully local, open-source, and privacy-focused text-to-SQL tool designed to help developers extract valuable insights from their PostgreSQL databases.

This project is my personal take on combining LLM tool calling, structured responses, and modern AI integrations to create a smooth and intuitive workflow.


Features

  • Self-hosted via Docker
  • Multi-user profiles
  • Organize your work in workspaces
  • Automatic SQL generation from natural-language prompts (only SELECT)
  • Automatic database table context generation with optional manual management
  • Chat and SQL history
  • Data visualization with auto-generated ShadcnUI charts
  • Fully local, open source and powered by Ollama

Technology Stack

  • Next.js 15
  • TypeScript
  • Tailwind CSS
  • ShadcnUI

Installation

Prerequisites

  • Docker Desktop installed and running
  • A configured .env file with the necessary environment variables (see .env.example for guidance)

Steps

  1. Clone the repository

    git clone <repo-url>
    cd vibedb
  2. Configure ENV

    • see .example.env for example configuration
  3. Build docker containers

    docker compose up --build -d

Testing

  • For testing use some spare database, I suggest Pagila

Licence

Licenced under MIT licence

Contributing

Contributions are welcome and appreciated!
Whether it’s fixing a bug, adding a new feature, or improving the documentation, your help makes VibeDB better.

About

A privacy-first, local Next.js app using Ollama to turn plain text into SQL queries for PostgreSQL.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages