run_query
Execute a read-only query against any connected database and get results back. Writes are blocked by default and require an explicit grant.
LABSCO SUMMARY
Three tools, and the important one is that two of them are read-only by construction.
Most database MCP servers hand an agent a SQL socket and rely on prompting for safety. This one blocks writes at the server and meters queries per key, which turns 'the agent can query production' from a policy into a limit. The schema tool matters more than it looks: without it a model guesses column names, and the query fails for reasons that have nothing to do with the question.
What it is
Ai2sql's hosted endpoint. It holds the database connections; the agent asks for a query and gets rows back. Writes are blocked by default, so a bad prompt cannot change data.
What you get
- run_query — execute a read-only query against any connected database
- describe_schema — tables, columns and relationships, so generated SQL fits the real model
- list_connections — enumerate the databases the current key can reach
Requirements
An API key sent as a bearer token; keys are scoped and metered individually. Plans start at $9/mo for 100 queries and 10 tables, with a 7-day trial; Oracle, MongoDB and BigQuery come in at the $24 tier.
Setup effort
Paste a URL with a key — add the endpoint to your client
USE CASES
01
Answering a data question without writing SQL
Ask in business terms; it reads the schema first so the generated query uses the columns that actually exist, then runs it read-only.
02
Checking what an agent can reach
List the connections tied to the current key before granting it to anything.
03
Letting a non-analyst pull a number
Metered, read-only access means handing out a scoped key is a bounded decision rather than a database grant.
3 tools
Listed in project docs. Your client may show a different list.
describe_schema
Tables, columns and relationships, so generated SQL matches your data model.
list_connections
Enumerate the databases available to the current API key.
BEFORE YOU INSTALL
What to know first
Tools you get
3 tools named in the project's documentation.
Requires
- an MCP client that can reach a remote endpoint
- API key (Authorization: Bearer <AI2SQL_KEY>, scoped keys, metered per key)
INSTALLATION
Connect your client
Add the endpoint to your client.
Server setup
ENDPOINT URL
https://builder.ai2sql.io/api/mcpRequirements
- API key (Authorization: Bearer <YOUR_AI2SQL_KEY>, scoped keys, metered per key)
