Loading...
SQL Chat

SQL Chat

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

About SQL Chat

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

Information

  • GPTs Creator askyourdatabase.com
  • Categories Research
  • GPT Updated February 07,2024
  • Updated about 5 hours

Capabilities

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

Share recipient

  • OpenAI‘s GPT Store Public

Timeline

SQL Chat
SQL Chat

By askyourdatabase.com

Hello, ready to unlock insights?

4.3
Ratings (18)
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.

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
Code Interpreter / Data Analysis Execute Python code for automation, calculations, and data analysis. Python
Web Browsing Real-Time Access and search the internet for information, articles, and data. Browser

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. 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 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-02-07 10:24:29 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

AutoExpert (Chat)
AutoExpert (Chat)
by Dustin Miller
Tired of lightweight answers? I am the ideal GPT for the curious human that always wants to learn more. I'll impanel a dynamic group of experts to answer, debate, and drill into any question or topic. Type /help for more info on my capabilities.
100K 4.5
Imaginative Edit, Recreate & Merge
Imaginative Edit, Recreate & Merge
by neural.love
Replicate Image, Images Merge, Image Edit, Style Transfer. Use "Help" for more info. 20+ features of the source image will be transferred. You also can call this GPT via @ in any chat (desktop only).
100K 3.5
Finance Wizard
Finance Wizard
by titantrades.com
I predict future stock market prices. AI analyst. Your trading analysis assistant. If you get an error, try again in a new chat or try rewording your prompt. Sometimes has trouble fetching data. Press H to bring up prompt hot key menu. Not financial advice.
100K 3.8
PDF Ai PDF
PDF Ai PDF
by myaidrive.com
Securely store and chat with ALL your PDFs for FREE, even x-large PDFs! Ai PDF powers more than 600,000 chats with professionals and researchers. It includes free myaidrive.com storage account, while Pro version can search folders with 1000s of files, OCR and extract title, authors and more!
700K 4.2
AskYourPDF Research Assistant
AskYourPDF Research Assistant
by askyourpdf.com
Access 400M+ Papers (PubMed, Nature, etc), Best Chat PDF (Unlimited PDFs), Generate articles/essays with valid citations, ChatPDF, Analyse and generate references for papers, create and interact with a knowledge base of your files and much more using AskYourPDF.
500K 4.0
Video Summarizer
Video Summarizer
by thegeneralmind.com
YouTube video summarizer | summaries, chat with Youtube video
100K 2.7

Top