Skip to content
Amity SolutionsAmity SolutionsAmity Solutions Docs

Data Analyst Agent

Perform data search on SQL database

To enhance data analysis capabilities, developers must activate the Query_SQL tool exclusively through API integration. This step is vital for maximizing the potential of the Data Analyst Agent and obtaining insightful results through SQL queries.

    "tools": {
        "query_sql": {
            "toolName": "query_sql",
            "config": {
                "usage_description": "Use this tool to query the data for every question from The Redshift Database, Except the report generation requested.",
                "db_type": "postgres",
                "db_config": {
                    "host": "{{host}}",
                    "port": {{port}},
                    "user": "{{string}}",
                    "password": "{{string}}",
                    "database": "{{string}}"
                },
                "sql_translator_endpoint": "{{sql_translator_endpoint}}"
            }
        }
    }