{"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,"search_vec":"'100':90 '18':103 '3456':77 'activ':96 'ai':28,106 'ambigu':49 'anthrop':31 'app':75 'automat':60 'bound':86 'clarif':43 'cli':111 'databas':13,105 'describ':39 'design':53,84 'develop':97 'document':61 'english':17 'execut':46 'file':68 'generat':36 'github':99 'insight':65 'interfac':8 'javascript':104 'languag':7,110 'like':30 'limit':88 'llm':112 'local':73 'markdown':67 'mysql':12 'natur':6,109 'natural-languag':108 'node.js':102 'non':56 'non-techn':55 'ollama':34 'openrout':32 'per':92 'plain':16 'port':76 'postgresql':10 'provid':29 'queri':25,63,93 'question':18 'read':22,81 'read-on':21,80 'resolv':48 'result':87 'row':91 'run':70 'safe':20 'schema':62 'select':37 'sql':24,107 'statement':40 'step':44 'support':101 'technic':57 'tool':51 'translat':15 'use':27 'user':58 'v0.3.5':3 'vordbest':1,2 'web':74","created_at":"2026-04-27T17:08:01.786941+00:00","updated_at":"2026-04-27T17:08:01.786941+00:00","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,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":"vordbeste","cli_version":null,"type":"library","homepage":null,"github":"https://github.com/festoinc/vordbeste","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/vordbeste","openapi_spec":null,"status_page":null,"smithery":null,"categories":["llm-agents","database","ai-ml","web-framework"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-18","next_check":"2026-07-26","install_tag":null}}