ai_query_mssql
Generate and execute safe read-only MSSQL SELECT queries from natural language instructions using Gemini AI. Validate queries and return results with configurable row limits and schema restrictions.
Instructions
Generate a safe read-only MSSQL SELECT from instruction via Gemini, validate, execute, and return rows.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| allowedSchemas | No | Optional whitelist of schemas (e.g., ['dbo','sales']) | |
| allowedTables | No | Optional whitelist of fully qualified tables (e.g., ['dbo.customer_dummy']) | |
| instruction | Yes | Natural language request to query MSSQL (Thai/English) | |
| maxRows | No | Max rows to return |