Hey everyone. A quick but exciting update! Text2Query just got a lot smarter at understanding what kind of SQL flavor your database is using.
Think of it like this: most tools speak generic SQL. But Text2Query now understands the nuances effortlessly switching between different SQL flavors and MongoDB, like someone fluent in multiple dialects.
Now, when you upload a schema, the app automatically detects whether it s PostgreSQL, MySQL, SQL Server, or MongoDB, and adapts the queries and syntax accordingly.
Just upload your schema. Text2Query detects the dialect instantly and:
Text2Query
The Problem π―
As a developer working with multiple databases β for research, product work, or quick prototypes β I often needed to write SQL or MongoDB queries from scratch. But thatβs not always quick or intuitive, especially across different schemas or languages.
And I realized: Iβm not the only one.
- Product managers often need answers now β not after asking an engineer
- No-code and low-code builders hit walls with query syntax
- Researchers and academics work with structured data but donβt always speak SQL
- Founders and solo devs just want to move fast without getting stuck writing joins
The Solution π
So I built Text2Query β a simple, privacy-first tool that lets you:
π Upload a schema (SQL or MongoDB)
π¬ Ask questions in plain English or Spanish
π§ Get valid, explainable queries instantly
π Reuse and tweak results from your session
π Runs entirely in your browser β no data is stored
How It Helps Me (and hopefully you too) π‘
Whether you're validating a hypothesis, exploring product metrics, or just trying to get an app working β query friction is real. I wanted a tool that removes that barrier without requiring new software, signups, or learning curves.
Built With βοΈ
@Python, @Streamlit, and OpenAI β no backend, no database. Just a clean UI and prompt logic that respects your privacy. Bring your own API key and work on your terms.
Thanks for checking it out! Would love to hear your thoughts, feedback, or wild use cases π
π Try it here (or give it an upvote if it makes your life easier):
https://text2query.com/
https://text2-query.streamlit.app/