Raw Query
Raw Query is an artificial intelligence tool designed to facilitate direct communication with databases using conversational language. This tool allows users, w...
Last verified:
What is Raw Query?
Raw Query is an AI-powered tool that lets you chat with your database using plain English instead of writing SQL. It uses state-of-the-art AI to understand your questions and automatically generates and executes the appropriate database queries, returning results in a conversational interface. The tool can query data, export results as CSV files, insert new data into your database, and update existing records.
Key features include instant database connection using just a connection string (takes 10 seconds), CSV export functionality, smart confirmation before inserting new data, and mobile device support for chatting with your data from anywhere. The tool supports Postgres, MySQL, and MariaDB databases, with Postgres being the only database that supports insert and update operations while MySQL and MariaDB can only select data.
Raw Query is designed for developers who want to avoid building endless internal tools, and for Business Intelligence professionals who don't want to learn SQL or track endless links for internal tools. It saves time by eliminating the need to learn complex database software or wait for developers to create queries, making data accessible to anyone who can speak plain English.
Raw Query pricing
Pricing model: Freemium
Free: $0 USD/month with 300 successful queries/month, 1 seat, 2 databases. Starter: $39 USD/month with 1500 successful queries/month, 5 seats, unlimited databases, priority support. Pro: $79 USD/month with 5000 successful queries/month, 10 seats, unlimited databases, priority support. Enterprise: $149 USD/month with 20000 successful queries/month, unlimited seats, unlimited databases, priority support, role access per database. Free tier available with no credit card required.
Raw Query pros
- Chat with database using plain English instead of SQL
- Connect database in just 10 seconds with connection string
- No SQL knowledge required
- Export query results as CSV files
- Insert new data into database with AI confirmation
- Update existing records easily
- Mobile device support for remote access
- No need to build internal tools for developers
- Priorty support on paid plans
- Unlimited databases on paid plans
- Hashed connection string storage for security
- Never stores actual user data
- Free tier with 300 queries per month
- Role access per database on $149 plan
- Unlimited seats on $149/month plan
- AI asks for clarification when more context needed
- Failed queries don't count against monthly quota
- Works with Postgres, MySQL, and MariaDB
Raw Query cons
- Only Postgres supports insert and update operations
- MySQL and MariaDB can only select data
- Monthly query limits on all plans
- 300 query limit on free tier
- Requires database connection string access
- AI may need more specific context for complex queries
- No offline functionality mentioned
- Limited to three database types only
Frequently asked questions about Raw Query
What does 'plain English' mean in Raw Query?
Plain English means you can ask questions using regular language instead of writing SQL code. For example, instead of writing SQL to find the email of the last five clients, you can simply ask 'What's the email of the last five clients that signed up?' and Raw Query will understand and execute the query.
Can I downgrade my subscription to free?
Yes, you can update your subscription to a free one directly inside your settings at any time.
What happens if my query isn't successful?
Sometimes you need to provide more context or be more specific for the AI to help you. If that's the case, Raw Query doesn't count that query as successful and your monthly quota will not be affected.
Which databases does Raw Query support?
Raw Query currently supports Postgres, MySQL, and MariaDB. However, only Postgres is able to insert and update data. MySQL and MariaDB can only select data from your database.
Can I use Raw Query on mobile devices?
Yes, it does! You can chat with your data from anywhere with your mobile device.
Does Raw Query store my data?
No, Raw Query never stores any of your actual data. They just present the data to you and it never gets near their databases.
How is my connection string secured?
Your connection string is stored in Raw Query's database as a hashed value to ensure that even if someone leaks their whole database, your own databases would still be secure.
Who is Raw Query built for?
Raw Query is built for two main groups: Developers who have better things to do than create endless internal tools, and Business Intelligence professionals who don't want to learn database language or track endless links for internal tools.
What can I do with Raw Query besides querying data?
Besides querying data, you can export data as CSV files, insert new data into your database (with AI confirmation), and update existing records for any reason like correcting mistakes or client changes.
How long does it take to connect my database?
It takes just 10 seconds. The connection string is all you need to connect your database, and if you have your string in hand you can start chatting with your data right away.