Conversation management

{
  "name": "execute_sql_query",
  "description": "Use this to execute Trino SQL query using AWS Athena Engine version 3. In case of error you will get error message, you have to fix your query and try again. You can apply JOIN opperations. You should use only columns from get_database_schema function. You should use columns only for it's tables. You can join tables if needed using provided columns. You should check that column is not empty string before casting it to avoid errors like this INVALID_CAST_ARGUMENT: Cannot cast '' to BIGINT. You should never compare numbers with strings.You should NEVER call this function before get_database_schema has been called in the conversation. You should NEVER use columns names of the wrong table. You should NEVER cast comare number types to strings or char. You should ALWAYS limit query results by maximum 50. You should NEVER compare fields to NULL.",
  "parameters": {
    "type": "object",
    "properties": {
      "sql_query": {
        "type": "string",
        "description": "SQL query, that user asked. Table names has to be inside \"\". Subqueries are only supported for EXISTS, IN and Scalar subquery, A scalar subquery is a non-correlated subquery that returns zero or one row. It is an error for the subquery to produce more than one row. The returned value is NULL if the subquery produces no rows. Example: SELECT COUNT(*) FROM \"first-american-listings\" WHERE facalculateddaysonmarket != '' AND CAST(\"facalculateddaysonmarket\" as BIGINT) > 15. Example: {\"sql_query\": \"SELECT mtg1lender, COUNT(*) as count FROM \"table_09_fulllaunch-first-american-equity-broker-listings-assesor\" WHERE currentoriginallistingdate >= '2022-03-20' GROUP BY mtg1lender ORDER BY count DESC LIMIT 5\"}. To get current date use current_date constant"
      }
    },
    "required": [
      "sql_query"
    ]
  },
  "webhook_url": "https://webhook.site/8efe8cf4-b7b5-4864-8b89-0302bf9749eb"
}

{
  "name": "get_database_schema",
  "description": "Use this function to get database schema of AWS Athena with columns and descriptions based what data should be retrived. You should ALWAYS use unfolded descriptions.",
  "parameters": {
    "type": "object",
    "properties": {
      "question": {
        "type": "string",
        "description": "what data should be retrived"
      }
    },
    "required": [
      "question"
    ]
  },
  "webhook_url": "https://webhook.site/8efe8cf4-b7b5-4864-8b89-0302bf9749eb"
}

Function is created

{
  "function": {
    "name": "get_database_schema",
    "description": "Use this function to get database schema of AWS Athena with columns and descriptions based what data should be retrived. You should ALWAYS use unfolded descriptions.",
    "parameters": {
      "type": "object",
      "properties": {
        "question": {
          "type": "string",
          "description": "what data should be retrived"
        }
      },
      "required": [
        "question"
      ]
    },
    "webhook_url": "https://webhook.site/8efe8cf4-b7b5-4864-8b89-0302bf9749eb"
  }
}

Request data invalid

{
  "message": "Request body is invalid."
}

Forbidden

{
  "message": "Invalid Api Key"
}

{
  "system_prompt": "You are ChatBot called ChatMTG by US Mortgage data company called staircase. You should help users with his question about the data. NEVER mention any table or column name."
}

System prompt is created

{
  "system_prompt": "You are ChatBot called ChatMTG by US Mortgage data company called staircase. You should help users with his question about the data. NEVER mention any table or column name."
}

Request data invalid

{
  "message": "Request body is invalid."
}

Forbidden

{
  "message": "Invalid Api Key"
}

{
  "temperature": 0.55
}

System prompt is created

{
  "temperature": 0.55
}

Request data invalid

{
  "message": "Request body is invalid."
}

Forbidden

{
  "message": "Invalid Api Key"
}

Functions

{
  "functions": [
    {
      "name": "get_database_schema",
      "description": "Use this function to get database schema of AWS Athena with columns and descriptions based what data should be retrived. You should ALWAYS use unfolded descriptions.",
      "parameters": {
        "type": "object",
        "properties": {
          "question": {
            "type": "string",
            "description": "what data should be retrived"
          }
        },
        "required": [
          "question"
        ]
      },
      "webhook_url": "https://webhook.site/8efe8cf4-b7b5-4864-8b89-0302bf9749eb"
    }
  ]
}

Request data invalid

{
  "message": "Request body is invalid."
}

Forbidden

{
  "message": "Invalid Api Key"
}

System prompt

{
  "system_prompt": "You are chatbot called ChatMTG by US Mortgage data company called staircase. You should help users with his question about the data. NEVER mention any table or column name."
}

Request data invalid

{
  "message": "Request body is invalid."
}

Forbidden

{
  "message": "Invalid Api Key"
}

Resource is not found

{
  "message": "Job not found."
}

Temperature

{
  "temperature": 0.55
}

Request data invalid

{
  "message": "Request body is invalid."
}

Forbidden

{
  "message": "Invalid Api Key"
}

Resource is not found

{
  "message": "Job not found."
}

Function

{
  "function": {
    "name": "get_database_schema",
    "description": "Use this function to get database schema of AWS Athena with columns and descriptions based what data should be retrived. You should ALWAYS use unfolded descriptions.",
    "parameters": {
      "type": "object",
      "properties": {
        "question": {
          "type": "string",
          "description": "what data should be retrived"
        }
      },
      "required": [
        "question"
      ]
    },
    "webhook_url": "https://webhook.site/8efe8cf4-b7b5-4864-8b89-0302bf9749eb"
  }
}

Request data invalid

{
  "message": "Request body is invalid."
}

Forbidden

{
  "message": "Invalid Api Key"
}

Resource is not found

{
  "message": "Job not found."
}

Request data invalid

{
  "message": "Request body is invalid."
}

Forbidden

{
  "message": "Invalid Api Key"
}

Resource is not found

{
  "message": "Job not found."
}