Loading...
SQL Chat

SQL Chat

0 0
0.0
( None Rating )
5K Knowledge Action
DALLE•E Browsing Data Analysis

About SQL Chat

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

Information

  • GPTs Creator askyourdatabase.com
  • Categories Research
  • GPT Updated 6 days
  • Updated about 4 hours

Knowledge File

  • Adobe Portable Document Format (pdf)1
  • Totals1

Capabilities

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

Share recipient

  • OpenAI‘s GPT Store Public

Timeline

SQL Chat
SQL Chat

By askyourdatabase.com

4.4
Ratings (70)
Research
Category
5K+
Conversations
Try This GPT on ChatGPT
Here's my test db: postgres://iytfuoiy:[email protected]/iytfuoiy
Create a table for customer and suppiler.
Explain tables in this db.
Get me the total counts of students.
Message ChatGPT

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
DALLE•E Generate unique images based on textual descriptions provided. Dalle
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

FAQs

SQL Chat is a custom ChatGPT and been described as "Connect and chat with your databases without writing SQL code - Supports MySQL, PostgreSQL, MongoDB, SQL Server, Snowflake. by AskYourDatabase.".

Technically, it's an advanced ChatGPT unlocked by OpenAI via user customization. You can refer to it as the SQL Chat AI Agent powered by GPT-4.

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 LearnOneWord, Business Intelligence.

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-04-08 13:01:10 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 )

Similar GPTs

SQL AI
SQL AI
by AMEEN ABDUL SALAM
SQL Specialist to help your Database Administration easier
7
SQL
SQL
by ai-gen.co
An expert in SQL, offering guidance in queries, table joins, and database design.
40
DataBase Wiz
DataBase Wiz
by AiHubCentral
Expertise in database management and optimization.
0

Top