Launched this week
Text2Query
Turn plain language into powerful database queries
47 followers
Turn plain language into powerful database queries
47 followers
Turn natural language into SQL and MongoDB queries. Upload your schema, ask questions, and get results with clear explanations — no coding needed. Runs fully in your browser. Private, multilingual, beginner-friendly. Supports multiple databases.
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/
Text2Query
El problema 🎯
Como desarrollador que trabaja con múltiples bases de datos — ya sea para investigación, desarrollo de producto o prototipos rápidos — muchas veces me encontraba escribiendo consultas SQL o MongoDB desde cero.
Y no es rápido ni intuitivo, sobre todo cuando debes cambiar de esquemas o lenguajes de consulta.
Y me di cuenta de que no era el único:
- Los PMs necesitan respuestas ahora — no después de pedir ayuda a un dev
- Los desarrolladores no-code y low-code se atascan con la sintaxis de las consultas
- Los investigadores y académicos trabajan con datos estructurados, pero no siempre manejan SQL
- Fundadores y devs independientes quieren ir rápido sin perder tiempo escribiendo joins
La solución 🚀
Así nace Text2Query — una herramienta simple y privada que te permite:
📁 Subir tu esquema (SQL o MongoDB)
💬 Hacer preguntas en lenguaje natural (en inglés o español)
🧠 Obtener consultas listas para usar, con explicación incluida
🔁 Reutilizar y editar tus propias preguntas dentro de la sesión
🔒 Todo se ejecuta localmente en tu navegador — no se guarda nada
Por qué es útil para mí (y quizás también para ti) 💡
Ya sea para validar una hipótesis, explorar métricas de producto o simplemente hacer que una app funcione — escribir queries puede frenar el proceso o hacerlo muy frustrante.
Quería, y necesitaba, una herramienta ligera, fácil y simple que eliminara esa barrera sin pedir registros, instalaciones ni curva de aprendizaje. No necesitaba funcionalidades rebuscadas y complejas, solo lo necesario.
Construido con ⚒️
@python2, @Streamlit y @OpenAI — sin backend, sin base de datos. Solo una interfaz limpia con lógica de prompts que respeta tu privacidad. Puedes usar tu propia clave API y trabajar con total control.
¡Gracias por echarle un vistazo! Me encantaría recibir tus ideas, comentarios o casos de uso más locos 🙌
👉 Puedes probarlo aquí (y si te resulta útil, ¡un voto positivo también se agradece!):
https://text2query.com/
https://text2-query.streamlit.app/
I love that it’s privacy-first and runs entirely in the browser. Have you thought about adding schema auto-detection from a live DB connection (read-only) so users don’t even have to upload a schema file?
Text2Query
@timchengb Hi Tim,
I’m really glad you noticed the privacy-first approach. That was core to the design. Right now, nothing gets stored or logged, and schema files stay in memory for a single session only.
Schema auto-detection from a live database (read-only) is definitely something for next version. Basically, connect securely, introspect the schema (tables, fields, relationships), and pull just the structure. Without ever touching actual data.
I’ve held off for this lightweight MVP to keep it simple and self-contained, but a lightweight connector (PostgreSQL, SQLite, or MongoDB) is on the roadmap. Would love to hear which database you’d want support for first!
BestPage.ai
No way—natural language straight to database queries? I can’t count how many times I’ve fumbled with SQL syntax. Does it handle complex joins or nested queries too?
Text2Query
@joey_zhu_seopage_ai Thank you Joey!
In this lightweight version, it handles joins and filters across multiple tables well, especially when the schema includes foreign keys. It can attempt more complex nested queries, but those are still experimental and may need tweaking. I’d love to know what kind of complex queries you’re trying to run, that’s where I want to improve next on the next more robust version!