query_database
Execute read-only SQL queries against MariaDB/MySQL or Microsoft SQL Server databases using OAuth 2.0 authentication for secure data retrieval.
Instructions
Execute a read-only SQL query against one of the configured database connections. Pass connection with the name of the target (omit if only one connection exists — use list_connections to see the names and which engine each uses). Only read statements are allowed (SELECT/SHOW/DESCRIBE/EXPLAIN/WITH on MariaDB; SELECT/WITH and a small allowlist of sp_help / sp_columns / sp_tables procs on MSSQL). Results are capped at a configurable row limit (default 1000). Use list_schema first if you don't know the table structure.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | No | ||
| sql | Yes |