{"id":22963,"library":"vordbeste","title":"vorDBeste","description":"vorDBeste (v0.3.5) is a natural language interface for PostgreSQL and MySQL databases that translates plain English questions into safe, read-only SQL queries. It uses AI providers like Anthropic, OpenRouter, or Ollama to generate SELECT and DESCRIBE statements, with a clarification step before execution to resolve ambiguity. The tool is designed for non-technical users and automatically documents schemas, queries, and insights as markdown files. It runs as a local web app (port 3456) and is read-only by design, with bounded results (limited to 100 rows per query). It is actively developed on GitHub and supports Node.js 18+.","status":"active","version":"0.3.5","language":"javascript","source_language":"en","source_url":"https://github.com/festoinc/vordbeste","tags":["javascript","database","ai","sql","natural-language","cli","llm"],"install":[{"cmd":"npm install vordbeste","lang":"bash","label":"npm"},{"cmd":"yarn add vordbeste","lang":"bash","label":"yarn"},{"cmd":"pnpm add vordbeste","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"This package is a CLI tool, not a library. Run via npx or global install.","wrong":"require('vordbeste')","symbol":"vordbeste","correct":"npx vordbeste"},{"note":"There is no programmatic API; the package only exports a CLI.","wrong":null,"symbol":"default","correct":"import vordbeste from 'vordbeste'"}],"quickstart":{"code":"npm install -g vordbeste && vordbeste\n# Open http://localhost:3456 in your browser\n# Follow the setup wizard to connect your database and AI provider\n# Ask: \"Show me the top 5 customers by total order amount\"","lang":"javascript","description":"Install global CLI and launch web UI to interact with database via natural language."},"warnings":[{"fix":"Upgrade Node.js to version 18 or later.","message":"Requires Node.js >=18.0.0. Older versions will fail at runtime.","severity":"breaking","affected_versions":"<18.0.0"},{"fix":"Use a compatible database or run the tool with a supported dialect.","message":"Only PostgreSQL and MySQL databases are supported. Other databases (SQLite, MSSQL, etc.) will not connect.","severity":"breaking","affected_versions":">=0.0.0"},{"fix":"Copy the ~/.vordbeste directory to the new machine, or re-enter keys in the setup page.","message":"The AI provider key (Anthropic, OpenRouter) is configured via the web UI and stored locally in ~/.vordbeste. If you move machines, you must reconfigure.","severity":"gotcha","affected_versions":">=0.0.0"},{"fix":"Use the 'LIMIT' command explicitly in your question if you need more rows, but the hard cap is 1000.","message":"All queries are automatically limited to 100 rows. This may inadvertently restrict answers that require full datasets (e.g., aggregate counts across large tables).","severity":"gotcha","affected_versions":">=0.0.0"},{"fix":"Keep the read-only mode enabled and do not grant database user write permissions.","message":"The tool does not execute write operations, but the AI may still generate unsafe SQL if misconfigured. Always review generated queries in the confirmation step.","severity":"gotcha","affected_versions":">=0.0.0"}],"env_vars":null,"last_verified":"2026-04-27T00:00:00.000Z","next_check":"2026-07-26T00:00:00.000Z","problems":[{"fix":"Run 'npm install -g vordbeste' to install it globally.","cause":"The package is not installed globally or locally.","error":"Error: Cannot find module 'vordbeste'"},{"fix":"Stop the other process or use a different port by setting the PORT environment variable (e.g., PORT=3457 vordbeste).","cause":"Port 3456 is already in use by another process.","error":"Error: listen EADDRINUSE :::3456"},{"fix":"Ensure your MySQL server is running and the connection string in the setup page is correct.","cause":"MySQL database is not running or connection credentials are wrong.","error":"Error: connect ECONNREFUSED 127.0.0.1:3306"},{"fix":"Re-enter your API key in the settings page. Make sure it's active and has credits.","cause":"The API key for Anthropic or OpenRouter is invalid or missing.","error":"Error: AI provider request failed: 401 Unauthorized"}],"ecosystem":"npm","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}