MCPcopy Create free account

hub / github.com/caesarHQ/textSQL / functions

Functions186 in github.com/caesarHQ/textSQL

⨍ Functions 186◇ Types & classes 12↳ Endpoints 27
↓ 19 callersFunctioncapturePosthog
(eventName, properties)
client/censusGPT/src/utils/loggers/posthog.js:11
↓ 6 callersFunctionget_assistant_message_from_openai
( messages: List[Dict[str, str]], temperature: int = 0, model: str = "gpt-3.5-turbo",
api/app/api/utils/messages.py:12
↓ 6 callersFunctionget_few_shot_example_messages
(mode: str = "text_to_sql", scope="USA", n=-1)
api/app/api/utils/few_shot_examples.py:10
↓ 5 callersFunctionget_assistant_message
( messages: List[Dict[str, str]], temperature: int = 0, model: str = "gpt-3.5-0301",
byod/api/app/utils.py:48
↓ 5 callersFunctionget_few_shot_messages
(mode: str = "text_to_sql")
byod/api/app/utils.py:31
↓ 5 callersFunctionlogSentryError
(queryContext, err)
client/censusGPT/src/utils/loggers/sentry.js:14
↓ 4 callersFunctionexecute_sql
(sql_query: str)
api/app/api/utils/sql_gen/sql_helper.py:23
↓ 4 callersFunctionfetchBackend
(natural_language_query)
client/censusGPT/src/App.js:504
↓ 4 callersFunctionget_relevant_tables_from_lm
Identify relevant tables for answering a natural language query via LM
api/app/api/utils/table_selection/table_selection.py:104
↓ 4 callersFunctionget_table_schemas
(table_names: List[str] = None, scope="USA")
api/app/api/utils/table_selection/table_details.py:34
↓ 4 callersFunctionlog_apicall
(duration, provider, model, input_tokens, output_tokens, service, purpose, session_id=None, success=True, log_
api/app/api/utils/caesar_logging.py:19
↓ 3 callersFunctiongenerate_table_metadata
Generate table metadata
byod/api/app/setup/utils.py:248
↓ 3 callersFunctiongenerate_type_metadata
Generate metadata for user defined enum
byod/api/app/setup/utils.py:215
↓ 3 callersFunctionget_table_names
Get names of tables in the database
byod/api/app/setup/utils.py:179
↓ 3 callersFunctionget_type_names
Get names of user-defined types in the database
byod/api/app/setup/utils.py:149
↓ 2 callersFunctionclearMapLayers
()
client/censusGPT/src/App.js:144
↓ 2 callersFunctionextract_json_str_from_markdown
(assistant_message_content)
byod/api/app/visualization/utils.py:95
↓ 2 callersFunctionextract_text_from_markdown
(text)
api/app/api/utils/table_selection/table_details.py:15
↓ 2 callersFunctiongetCities
(result)
client/censusGPT/src/utils/utils.js:31
↓ 2 callersFunctiongetSuggestionForFailedQuery
()
client/censusGPT/src/App.js:183
↓ 2 callersFunctiongetZipcodes
(result)
client/censusGPT/src/utils/utils.js:17
↓ 2 callersFunctiongetZipcodesMapboxFormatted
(zips)
client/censusGPT/src/utils/utils.js:8
↓ 2 callersFunctionget_all_table_names
(scope="USA")
api/app/api/utils/table_selection/table_details.py:26
↓ 2 callersFunctionget_relevant_tables_from_pinecone
Identify relevant tables for answering a natural language query via vector store
byod/api/app/table_selection/utils.py:106
↓ 2 callersFunctionget_relevant_tables_from_pinecone
(natural_language_query, scope="USA")
api/app/api/utils/table_selection/table_selection.py:77
↓ 2 callersFunctionget_retry_prompt
Crates the retry prompt for the given scope formatted to the given dialect and schemas. Args: dialect (str): This is something I sho
api/app/api/utils/sql_gen/prompts.py:145
↓ 2 callersFunctionget_table_schemas_str
Format table and types metadata into string to be used in prompt
byod/api/app/table_selection/utils.py:66
↓ 2 callersFunctionisGeoColumn
(columnName)
client/censusGPT/src/utils/plotly-ui-config.js:5
↓ 2 callersFunctionlog_suggested_query
(input_text="", reason="", app_name="", parent_id=None, suggested_query="", prompt="", model="", session_id=No
api/app/api/utils/caesar_logging.py:177
↓ 2 callersFunctionreplace_unsupported_localities
(original_string, scope="USA")
api/app/api/routes.py:20
↓ 2 callersFunctionsave_table_metadata
Save table metadata to database
byod/api/app/setup/utils.py:18
↓ 2 callersFunctionsave_type_metadata
Save type metadata to database
byod/api/app/setup/utils.py:42
↓ 2 callersFunctionsend_message
(message, user_message, is_private)
api/discordbot/bot.py:6
↓ 2 callersFunctiontext_to_sql_with_retry
Tries to take a natural language query and generate valid SQL to answer it K times
api/app/api/utils/sql_gen/text_to_sql.py:37
↓ 2 callersFunctionupdate_input_classification
(id: str, ran_sql: bool, rows_returned: int, generated_sql: str)
api/app/api/utils/caesar_logging.py:128
↓ 1 callersFunction_extract_text_from_markdown
(text)
byod/api/app/table_selection/utils.py:165
↓ 1 callersFunction_extract_text_from_markdown
(text)
api/app/api/utils/table_selection/table_selection.py:14
↓ 1 callersFunction_get_failed_query_suggestion_message
(scope="USA", natural_language_query="")
api/app/api/utils/suggestions/suggestions.py:7
↓ 1 callersFunction_get_failed_query_suggestion_messages
(scope="USA")
api/app/api/utils/suggestions/suggestions.py:39
↓ 1 callersFunction_get_query_suggestion_message
(scope="USA", natural_language_query="")
api/app/api/utils/suggestions/suggestions.py:23
↓ 1 callersFunction_get_query_suggestion_messages
(scope="USA")
api/app/api/utils/suggestions/suggestions.py:60
↓ 1 callersFunction_get_table_selection_message_with_descriptions
(natural_language_query)
byod/api/app/table_selection/utils.py:128
↓ 1 callersFunction_get_table_selection_message_with_descriptions
(scope="USA")
api/app/api/utils/table_selection/table_selection.py:20
↓ 1 callersFunction_get_table_selection_messages
()
byod/api/app/table_selection/utils.py:144
↓ 1 callersFunction_get_table_selection_messages
(scope="USA")
api/app/api/utils/table_selection/table_selection.py:56
↓ 1 callersFunctionacceptSuggestion
(id)
client/censusGPT/src/components/suggestion.js:9
↓ 1 callersFunctioncalculate_cost
(model, input_tokens, output_tokens)
api/app/api/utils/caesar_logging.py:91
↓ 1 callersFunctioncall_chat
( messages: List[Dict[str, str]], temperature: int = 0, model: str = "gpt-3.5-turbo",
api/app/api/utils/messages.py:72
↓ 1 callersFunctioncitiesFeatures
(cities)
client/censusGPT/src/utils/mapbox-ui-config.js:17
↓ 1 callersFunctionclean_message_content
Cleans message content to extract the SQL query
byod/api/app/utils.py:65
↓ 1 callersFunctionclearAllButQuery
()
client/censusGPT/src/App.js:126
↓ 1 callersFunctioncreate_labels
Create labels for the user input
api/app/api/utils/classification/input_classification.py:9
↓ 1 callersFunctioncreate_session
(app_name, user_id)
api/app/api/utils/caesar_logging.py:228
↓ 1 callersFunctioncreate_viz_data_dict
(column_names, column_types, results)
byod/client/app.py:18
↓ 1 callersFunctionexecuteSql
(sql)
client/censusGPT/src/App.js:268
↓ 1 callersFunctionexecute_sql
(sql_query: str)
byod/api/app/sql_generation/utils.py:96
↓ 1 callersFunctionexplainSql
(sql)
client/censusGPT/src/App.js:422
↓ 1 callersFunctionextract_code_from_markdown
(assistant_message_content)
byod/api/app/utils.py:87
↓ 1 callersFunctionextract_sql_query_from_message
(assistant_message_content)
byod/api/app/utils.py:81
↓ 1 callersFunctionextract_sql_query_from_message
(assistant_message_content)
api/app/api/utils/messages.py:145
↓ 1 callersFunctionfetchExamples
()
client/censusGPT/src/contexts/feedContext.js:18
↓ 1 callersFunctiongenerate_suggestion
Get suggested query to build on top of a given query or as a similar query
api/app/api/utils/suggestions/suggestions.py:119
↓ 1 callersFunctiongenerate_suggestion_failed_query
Get suggested query based on failed query
api/app/api/utils/suggestions/suggestions.py:81
↓ 1 callersFunctiongetConnectionSpeed
()
client/censusGPT/src/vitals.js:3
↓ 1 callersFunctiongetPlotConfig
(rows, cols)
client/censusGPT/src/utils/plotly-ui-config.js:12
↓ 1 callersFunctiongetSession
()
client/censusGPT/src/App.js:162
↓ 1 callersFunctiongetSuggestionForQuery
()
client/censusGPT/src/App.js:225
↓ 1 callersFunctiongetTables
(natural_language_query)
client/censusGPT/src/App.js:452
↓ 1 callersFunctiongetUserId
()
client/censusGPT/src/utils/user.js:3
↓ 1 callersFunctionget_changed_vega
(command, vega_lite_spec)
byod/api/app/visualization/utils.py:80
↓ 1 callersFunctionget_current_user
Get current db user
byod/api/app/setup/utils.py:88
↓ 1 callersFunctionget_default_messages
()
byod/api/app/sql_explanation/utils.py:11
↓ 1 callersFunctionget_default_messages
()
api/app/api/utils/sql_explanation/sql_explanation.py:14
↓ 1 callersFunctionget_feed_data
(app)
api/app/api/utils/caesar_logging.py:251
↓ 1 callersFunctionget_message_with_descriptions
()
byod/api/app/sql_explanation/utils.py:4
↓ 1 callersFunctionget_message_with_descriptions
()
api/app/api/utils/sql_explanation/sql_explanation.py:6
↓ 1 callersFunctionget_minimal_table_schemas
(scope="USA")
api/app/api/utils/table_selection/table_details.py:160
↓ 1 callersFunctionget_relevant_tables_async
Identify relevant tables for answering a natural language query
api/app/api/utils/table_selection/table_selection.py:165
↓ 1 callersFunctionget_relevant_tables_from_lm
Identify relevant tables for answering a natural language query via LM
byod/api/app/table_selection/utils.py:172
↓ 1 callersFunctionget_sql_explanation
Use language model to generate explanation of SQL query
byod/api/app/sql_explanation/utils.py:20
↓ 1 callersFunctionget_sql_explanation
Use language model to generate explanation of SQL query
api/app/api/utils/sql_explanation/sql_explanation.py:25
↓ 1 callersFunctionget_table_and_enums
(table_names: List[str] = None, scope="USA")
api/app/api/utils/table_selection/table_details.py:97
↓ 1 callersFunctionget_vega_lite_spec
(data)
byod/api/app/visualization/utils.py:66
↓ 1 callersFunctionis_read_only_query
Checks if the given SQL query string is read-only. Returns True if the query is read-only, False otherwise.
byod/api/app/sql_generation/utils.py:71
↓ 1 callersFunctionis_read_only_query
Checks if the given SQL query string is read-only. Returns True if the query is read-only, False otherwise.
api/app/api/utils/sql_gen/sql_helper.py:100
↓ 1 callersFunctionload_in_context_examples
Setup in context examples dict
byod/api/app/utils.py:11
↓ 1 callersFunctionload_tables_and_types_metadata
Setup metadata dicts for tables and enums
byod/api/app/table_selection/utils.py:16
↓ 1 callersFunctionlog_input_classification
(app_name, input_text, metadata, parent_id, session_id=None)
api/app/api/utils/caesar_logging.py:100
↓ 1 callersFunctionlog_sql_failure
(input_text, sql_script, failure_message, attempt_number, app_name, session_id=None)
api/app/api/utils/caesar_logging.py:152
↓ 1 callersFunctionmain
()
byod/client/app.py:38
↓ 1 callersFunctionmake_default_messages
(schemas_str: str)
byod/api/app/sql_generation/utils.py:23
↓ 1 callersFunctionmake_default_messages
(schemas: str, scope="USA")
api/app/api/utils/sql_gen/text_to_sql_chat.py:17
↓ 1 callersFunctionmake_default_messages
(schemas: str, scope="USA", n=-1)
api/app/api/utils/sql_gen/text_to_sql.py:18
↓ 1 callersFunctionmake_default_visualization_change_messages
()
byod/api/app/visualization/utils.py:42
↓ 1 callersFunctionmake_default_visualize_data_messages
()
byod/api/app/visualization/utils.py:8
↓ 1 callersFunctionmake_msg_with_schema_and_warnings
()
byod/api/app/sql_generation/utils.py:57
↓ 1 callersFunctionmake_rephrase_msg_with_schema_and_warnings
()
api/app/api/utils/sql_gen/text_to_sql_chat.py:24
↓ 1 callersFunctionmake_visualization_change_message
()
byod/api/app/visualization/utils.py:56
↓ 1 callersFunctionmake_visualize_data_message
()
byod/api/app/visualization/utils.py:34
↓ 1 callersFunctionnotify
(err)
client/censusGPT/src/components/toast.js:3
next →1–100 of 186, ranked by callers