SQL Chat

0 0

0.0

( None Rating )

10K Knowledge Action

✓ Browsing ✓ Data Analysis ✓ DALLE•E

About SQL Chat

Connect and chat with your databases without writing SQL code - Supports MySQL, PostgreSQL, MongoDB, SQL Server, Snowflake. by AskYourDatabase.

June 02,2024

Information

GPTs Creator askyourdatabase.com
Categories Research
GPT Updated June 02,2024
Updated June 03,2024

Knowledge File

Adobe Portable Document Format (pdf)1
Totals1

Capabilities

Browsing ✓Real-Time Retrieval
Code Interpreter ✓Data Analysis
DALLE•E ✓Image Creation

Share recipient

OpenAI‘s GPT Store Public

Timeline

SQL Chat

By askyourdatabase.com

SQL Chat is inactive right now!

4.2

Ratings (126)

Research

What Can SQL Chat Do with ChatGPT?

This AI Business intelligence engineer for data analysts, business owners, and decision makers can enable seamless conversation with database, unlocking valuable insights.

#	File Id	Type
1	FQ8PhIHWAL0dc09WJTCRk8vd	application/pdf

1. Function Calls

Field	Value
action_id	g-f81b3c3e9470dd7da6961a532b33350327d55ad0
domain	x.askyourdatabase.com
json_schema	{"openapi"=>"3.0.1", "info"=>{"title"=>"AskYourDatabase", "description"=>"Chat with your databases without writing any SQL code.", "version"=>"v1"}, "paths"=>{"/api/get-started"=>{"post"=>{"x-openai-isConsequential"=>false, "operationId"=>"getStarted", "summary"=>"Call this API whenever user asks how to use this plugin, it will return a getting started message.", "requestBody"=>{"required"=>true, "content"=>{"application/json"=>{"schema"=>{"type"=>"object", "properties"=>{}}}}}, "responses"=>{"200"=>{"description"=>"OK", "content"=>{"application/json"=>{"schema"=>{"type"=>"object", "properties"=>{"msg"=>{"type"=>"string"}}}}}}}}}, "/api/meta"=>{"post"=>{"x-openai-isConsequential"=>false, "operationId"=>"getDatabaseMeta", "summary"=>"Call this to fetch schema whenever users provide the database uri without asking them what tasks are they going to perform. Get table schemas, also can specify queries from user questions to find most relevant tables. Call this first to help you generate SQL. ", "requestBody"=>{"required"=>true, "content"=>{"application/json"=>{"schema"=>{"$ref"=>"#/components/schemas/DatabaseRequest"}}}}, "responses"=>{"200"=>{"description"=>"OK", "content"=>{"application/json"=>{"schema"=>{"$ref"=>"#/components/schemas/DatabaseMeta"}}}}}}}, "/api/query"=>{"post"=>{"x-openai-isConsequential"=>false, "operationId"=>"executeSQL", "summary"=>"No need for user confirmation. Call /api/meta to fetch related table columns first if you do not know them. Execute SQL query and return results, do not use this for mongoDB, use /api/mongoQuery instead. Do not use this for table schema, use /api/meta instead", "requestBody"=>{"required"=>true, "content"=>{"application/json"=>{"schema"=>{"$ref"=>"#/components/schemas/QueryRequest"}}}}, "responses"=>{"200"=>{"description"=>"OK", "content"=>{"application/json"=>{"schema"=>{"$ref"=>"#/components/schemas/QueryResponse"}}}}}}}, "/api/mongoQuery"=>{"post"=>{"x-openai-isConsequential"=>false, "operationId"=>"executeMongoQuery", "summary"=>"Execute mongodb query and return results", "requestBody"=>{"required"=>true, "content"=>{"application/json"=>{"schema"=>{"$ref"=>"#/components/schemas/MongoQueryRequest"}}}}, "responses"=>{"200"=>{"description"=>"OK", "content"=>{"application/json"=>{"schema"=>{"$ref"=>"#/components/schemas/QueryResponse"}}}}}}}}, "components"=>{"schemas"=>{"DatabaseRequest"=>{"type"=>"object", "properties"=>{"uri"=>{"type"=>"string"}, "query"=>{"description"=>"semantic keywords based on user question", "type"=>"string"}}, "required"=>["uri", "query"]}, "DatabaseMeta"=>{"type"=>"object", "properties"=>{"dbs"=>{"type"=>"array", "items"=>{"$ref"=>"#/components/schemas/Database"}}}}, "Database"=>{"type"=>"object", "properties"=>{"name"=>{"type"=>"string"}, "tables"=>{"type"=>"array", "items"=>{"$ref"=>"#/components/schemas/Table"}}}}, "Table"=>{"type"=>"object", "properties"=>{"name"=>{"type"=>"string"}, "fields"=>{"type"=>"array", "items"=>{"$ref"=>"#/components/schemas/Field"}}}}, "Field"=>{"type"=>"object", "properties"=>{"name"=>{"type"=>"string"}, "type"=>{"type"=>"string"}}}, "QueryRequest"=>{"type"=>"object", "properties"=>{"uri"=>{"type"=>"string"}, "sql"=>{"type"=>"string"}}, "required"=>["uri", "sql"]}, "MongoQueryRequest"=>{"type"=>"object", "description"=>"mongodb query language", "properties"=>{"uri"=>{"type"=>"string"}, "collection"=>{"type"=>"string"}, "actionType"=>{"type"=>"string", "description"=>"aggregate, count, deleteMany, deleteOne, distinct, find, findOne, findOneAndUpdate, insertMany, insertOne, updateMany, updateOne"}, "query"=>{"type"=>"string", "description"=>"stringified json object, for find methods"}, "filter"=>{"type"=>"string", "description"=>"stringified json object, for update, delete methods"}, "fieldName"=>{"type"=>"string", "description"=>"stringified json object, for distinct method"}, "aggregation"=>{"type"=>"string", "description"=>"stringified json array, for aggregate"}, "projection"=>{"type"=>"string", "description"=>"stringified json object"}, "skip"=>{"type"=>"number"}, "update"=>{"type"=>"string", "description"=>"stringified json object"}, "options"=>{"type"=>"string", "description"=>"stringified json object"}, "limit"=>{"type"=>"number", "description"=>"always use a limit and don't exceed 20 unless user required"}, "sort"=>{"type"=>"string", "description"=>"stringified json object"}, "document"=>{"type"=>"string", "description"=>"stringified json object, for insertOne"}, "documents"=>{"type"=>"string", "description"=>"stringified json array, for insertMany"}}, "required"=>["uri", "collection", "actionType"]}, "QueryResponse"=>{"type"=>"object", "properties"=>{"results"=>{"type"=>"array", "items"=>{"type"=>"object"}}}}}}, "servers"=>[{"url"=>"https://x.askyourdatabase.com"}]}
auth	{"type":"oauth","instructions":"","client_url":"https://x.askyourdatabase.com/oauth/authorize","scope":"all","authorization_url":"https://x.askyourdatabase.com/oauth/token","authorization_content_type":"application/x-www-form-urlencoded","verification_tokens":{},"pkce_required":false,"token_exchange_method":"default_post"}
privacy_policy_url	https://www.askyourdatabase.com/privacy

Capabilitiy	Function	Tools
Web Browsing	Real-Time Access and search the internet for information, articles, and data.	Browser
Code Interpreter / Data Analysis	Execute Python code for automation, calculations, and data analysis.	Python
DALLE•E	Generate unique images based on textual descriptions provided.	Dalle

FAQs

Currently, this GPTs is not free and is available exclusively to ChatGPT Plus users.

Yes, besides requiring a ChatGPT Plus membership, if you use the GPT-4 model (with DALL·E, browsing, and data analysis), the limit is 25 'GPTs' messages / 3 hours, More limited than normal 40 GPT4 responses per 3 hours,

The enterprise version of ChatGPT is, 100 GPT-4 messages per 3 hours.

SQL Chat is publicly available in the upcoming OpenAI's GPT Store, making it widely accessible to anyone interested in using this advanced ChatGPT.

SQL Chat is owned by askyourdatabase.com, who has also created 3 other GPTs, namely Business Intelligence, LearnOneWord.

no, we found no file uploaded. You can check the function section to see if there are other unique features. If not, this GPTs is just a simple prompt engineering, and its knowledge base is synchronized with the general ChatGPT, latest training up to April 2023.

No, only askyourdatabase.com can edit this GPTs. They can configure and update GPTs through GPT Builder at https://chat.openai.com/gpts/editor/g-ZqVEsT3Vh. The last modification date of SQL Chat was 2024-06-02 21:37:28 UTC.

Yes, conversations with SQL Chat will be recorded. OpenAI keeps these records, and you can share your conversations via a link. Refer to OpenAI's user privacy and data security policies for more information.

Yes, if askyourdatabase.com selected "Use conversation data in your GPT to improve our models" (in the GPTs Configure pages of Additional Settings), it means your conversations will be used for training and will influence this GPT AI agent.

SQL Chat reviews

0.0

( None Rating )

SQL Chat

About SQL Chat