db_query
Execute SQL SELECT queries on MySQL, Oracle, GaussDB, and DM8 databases with configurable row limits and database selection.
Instructions
Execute SQL queries against configured databases (MySQL, DM8, Oracle, GaussDB).
Available databases:
mysql-dev (mysql): SELECT
gaussdb-dev (gaussdb): SELECT
oracle-dev (oracle): SELECT
dm8-dev (dm8): SELECT
Default database: mysql-dev
Use 'db_query' for SELECT queries, 'db_execute' for INSERT/UPDATE/DELETE/DDL operations.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL SELECT query to execute | |
| maxRows | No | Maximum number of rows to return (default: 100) | |
| database | No | Database ID to query (default: mysql-dev). Available: mysql-dev, gaussdb-dev, oracle-dev, dm8-dev |