Text-to-SQL

AI-powered SQL generation through MCP (Model Context Protocol) for Claude Desktop, Cursor, and Windsurf.

macOS/Linux: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json

macOS/Linux: ~/.cursor/mcp.json Windows: %USERPROFILE%\.cursor\mcp.json

macOS/Linux: ~/.codeium/windsurf/mcp_config.json Windows: %USERPROFILE%\.codeium\windsurf\mcp_config.json

{ "mcpServers": { "onesql": { "command": "python3", "args": ["-c", "import urllib.request; exec(urllib.request.urlopen('<https://aws.api.onekq.ai/mcp-server.py>').read())"], "env": {"ONESQL_API_KEY": "your-api-key"} } } }

Add "type": "stdio" for Cursor

Extract tables from this text: Sales Report: | Product | Q1 | Q2 | |---------|----|----| | Widget | 100| 150| | Gadget | 75 | 90 | Upload the following schemas with alias commerce: CREATE TABLE users (id INT PRIMARY KEY, email VARCHAR(255), created_at TIMESTAMP); CREATE TABLE products (id INT PRIMARY KEY, name VARCHAR(255), price DECIMAL(10,2), inventory INT); CREATE TABLE orders (id INT PRIMARY KEY, user_id INT, total DECIMAL(10,2), order_date TIMESTAMP); CREATE TABLE order_items (id INT PRIMARY KEY, order_id INT, product_id INT, quantity INT, price DECIMAL(10,2)); List all schema aliases Show all schemas under the alias commerce Delete the commerce schema Using the commerce alias, find top 5 customers by total spending With the commerce alias, show products with low inventory With the commerce alias, find users who haven't ordered in 30 days