generateSql
Convert natural language questions into SELECT SQL queries for database analysis using Alibaba Cloud DMS MCP Server, simplifying data query generation across diverse databases.
Instructions
Generate SELECT-type SQL queries from natural language input.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
database_id | Yes | DMS databaseId | |
knowledge | No | Additional context | |
question | Yes | Natural language question |
Input Schema (JSON Schema)
{
"properties": {
"database_id": {
"description": "DMS databaseId",
"title": "Database Id",
"type": "string"
},
"knowledge": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"description": "Additional context",
"title": "Knowledge"
},
"question": {
"description": "Natural language question",
"title": "Question",
"type": "string"
}
},
"required": [
"database_id",
"question"
],
"title": "nl2sqlArguments",
"type": "object"
}