query_database
Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH) on MariaDB or MSSQL databases. Results are capped at a configurable row limit for safe, restricted access.
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 |