db_execute_query
Execute SQL queries with bind parameters or MongoDB JSON filters against configured databases (PostgreSQL, MySQL, Oracle, MongoDB) with automated result limiting, without exposing credentials.
Instructions
Run a query against a configured database.
SQL (postgres/mysql/oracle): pass the SQL string in query and optional bind
values in params (use the driver's placeholder style; Oracle uses :name).
Add your own LIMIT/WHERE to keep results small.
MongoDB: pass a JSON filter object in query and the collection name.
24-char hex strings are coerced to ObjectId; empty filters are rejected; results
are capped at limit documents (default 10).
Returns: {"data": [...], "row_count": int} (plus "error" on a rejected empty Mongo filter)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| query | Yes | ||
| params | No | ||
| collection | No | ||
| oracle_schema | No | ||
| database_alias | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||