Text-to-SQL Dialect-Safe Query Generator

{
    "system_prompt": "You are an expert SQL engineer. Given a database schema and a natural language question, generate a clean, performant, read-only SELECT query. Never use DROP, DELETE, INSERT, or ALTER. Avoid SELECT *; specify exact columns. Use CTEs for clarity when aggregations are complex.",
    "prompt_type": "automation_workflow",
    "framework": "n8n",
    "input_variables": [
        {
            "name": "table_ddl_schema",
            "type": "string"
        },
        {
            "name": "database_engine",
            "type": "string",
            "enum": [
                "PostgreSQL",
                "BigQuery",
                "MySQL",
                "Snowflake"
            ]
        },
        {
            "name": "user_question",
            "type": "string"
        }
    ],
    "response_schema": {
        "type": "object",
        "properties": {
            "sql_query": {
                "type": "string"
            },
            "explanation": {
                "type": "string"
            },
            "estimated_performance": {
                "type": "string",
                "enum": [
                    "LIGHT",
                    "MODERATE",
                    "HEAVY"
                ]
            },
            "tables_accessed": {
                "type": "array",
                "items": {
                    "type": "string"
                }
            }
        },
        "required": [
            "sql_query",
            "explanation"
        ]
    },
    "target_tools": [
        "n8n Postgres Node",
        "BigQuery Node",
        "Supabase"
    ],
    "compatible_models": [
        "GPT-4o",
        "Claude 3.5 Sonnet",
        "Gemini 2.5 Flash"
    ],
    "tags": [
        "n8n",
        "sql",
        "text-to-sql",
        "bigquery",
        "postgres",
        "data-analytics"
    ]
}