Golden SQLs

In order to improve the perfromance of NL-to-SQL engines, our system includes a few verfied Question SQL samples in the prompts. As more samples are verfied, the performance of the NL-to-SQL engine not only improves in terms of accuracy but also improves in terms speed. The verfied Question SQL samples are called golden sqls. These golden sqls are stored in vector database for fast retrieval and also in our application storage for easy access and management.

Add golden sqls

You can add golden sql to the system by sending a POST request to the /api/v1/golden-sqls endpoint.

Request this POST endpoint:

/api/v1/golden-sqls

Request body

[
 {"prompt_text": "prompt_text", "sql": "sql", "db_connection_id":"db_connection_id"},
]

Responses

HTTP 201 code response

[
 {"id": "id", "prompt_text": "prompt_text", "sql":"sql", db_connection_id: "db_connection_id"},
]

Example

 curl -X 'POST' \
'http://localhost/api/v1/golden-sqls' \
-H 'accept: application/json' \
-H 'Content-Type: application/json' \
-d '[
{
  "prompt_text": "what was the median home sale price in Califronia in Q1 2021?",
  "sql": "SELECT location_name, period_end, metric_value FROM redfin_median_sale_price rmsp WHERE geo_type = '\''state'\'' AND location_name='\''California'\'' AND property_type = '\''All Residential'\''   AND period_start BETWEEN '\''2021-01-01'\'' AND '\''2021-03-31'\'' ORDER BY period_end;",
  "db_connection_id": "64dfa0e103f5134086f7090c",
}]'

Delete golden sql

You can delete a golden sql by sending a DELETE request to the /api/v1/golden-sqls/{golden_sql_id} endpoint.

Request this DELETE endpoint:

/api/v1/golden-sqls/{golden_sql_id}

Parameters

Name	Type	Description
golden_sql_id	string	Generated golden sql id, Required

Responses

HTTP 200 code response

{"status": true}

Example

 curl -X 'DELETE' \
'http://localhost/api/v1/golden-sqls/64e503fa85dbfee0d981f8ce' \
-H 'accept: application/json'

Get golden sqls

Request this GET endpoint:

/api/v1/golden-sqls

Parameters

Name	Type	Description
db_connection_id	string	db connection id, Optoinal
page	integer	Page number, Optoinal
limit	integer	Page size, Optoinal

Responses

HTTP 200 code response

[
{"id": "id", "prompt_text": "prompt_text", "sql":"sql", db_connection_id: "db_connection_id"},
]

Example

 curl -X 'GET' \
'http://localhost/api/v1/golden-sqls?page=1&limit=10&db_connection_id=2342344' \
-H 'accept: application/json'