Focus on the questions,
not the query.
Chat freely with your database
powered by the latest in AI technology.
Generate SQL queries and custom API endpoints with ease and get the answers you need.
Works with PostgreSQL, Supabase.
Tired of coming up with queries and API endpoints?
Developers without chat2query
- Manually create queries instead of chatting with your db
- Manually create API endpoints
- Waste hours debugging
- Add caching
- Cannot answer questions about your business in real-time
Developers with chat2query
- Automatically generate queries
- Automatically generate API endpoints
- Save hours
- Automatically caching
- Answer questions about your business in quick time
Demo
Frequently Asked Questions
How do I get started?
All you need is a database url (PostgreSQL or SupaBase) and an openai key. That's it! You can start chatting with your database right away. (see demo)
Do you send the database data to openai?
No, we generate the schema of your database ofline and we send the schema along with your question to get back a query which we can execute on our server. The language model nevers sees the query results nor queries your database. Later, when analytics are enabled we might offer you that option.
What type of databases do you currently support?
Currently, the system is compatible with PostgreSQL, SupaBase.
How do I get my database url?
Your database url is the connection string that you use to connect to your database. It usually looks like this: postgres://username:password@hostname:port/dbname
Do you offer api endpoints for the queries i generated?
Great question! Yes we do! You can customize the fields and get a unique url to use in tools like appsmith or your own dashboard! (see demo)
What language models do you currently support?
We currently support by default the gpt-3-turbo language model from OpenAI. Options such as Anthropic and others will be available soon. (see demo)
How do I get my openai key?
You can get your openai key by signing up at openai.com and creating a new api key. You can then use this key to connect to our service. (https://help.openai.com/en/articles/4936850-where-do-i-find-my-openai-api-key)
How do you ensure the security of my data?
We take security very seriously. We encrypt your database url and your openai key. This means that if some malicius actor gets access to our database, they won't be able to see your data or access your resources.
What is in the roadmap for chat2query.com?
We are currently working on a Slack bot so you can chat like: '@dbaichat how much revenue from payments has user 1 made in the year 2024', webhook support, background jobs, increased query and api call limits, preserve data history, sqlite support, and more! We are working hard to bring you the best experience possible. Stay tuned!
Will chat2query.com generate destructive queries?
No, the context provided to the language model instructs it to only generate SELECT queries. In case it does do not worry because the final execution is up to you. Chats are not auto executed currently. (see demo)
© 2024 pamfili.co