Back to articles
Outerbase Has a Free API: Visual Database Interface with AI-Powered SQL Generation

Outerbase Has a Free API: Visual Database Interface with AI-Powered SQL Generation

via Dev.to TutorialAlex Spinov

What is Outerbase? Outerbase is a visual database interface — like phpMyAdmin meets Notion, with AI. Connect any database (PostgreSQL, MySQL, SQLite, SQL Server, ClickHouse), browse data visually, and generate SQL with natural language. Free tier: unlimited connections, unlimited queries. Connect Your Database # Outerbase connects to any database via connection string # PostgreSQL: postgres://user:pass@host:5432/db # MySQL: mysql://user:pass@host:3306/db # SQLite: file:./database.sqlite The REST API (EZQL) Outerbase provides EZQL — an API that turns natural language into SQL: export OB_URL = "https://app.outerbase.com/api/v1" export OB_TOKEN = "your-api-key" Natural Language Queries # Ask in plain English curl -X POST " $OB_URL /ezql" \ -H "Authorization: Bearer $OB_TOKEN " \ -H "Content-Type: application/json" \ -d '{ "query": "Show me the top 10 customers by total order value this month", "connection_id": "CONNECTION_ID" }' Outerbase generates the SQL, runs it, and returns results —

Continue reading on Dev.to Tutorial

Opens in a new tab

Read Full Article
2 views

Related Articles