Overview
YourQL is a desktop application that connects to your databases and lets you ask
questions in natural language. YourQL runs entirely on your computer. We do not
operate backend servers that store or process your data.
Data YourQL accesses
When you connect YourQL to your databases or Google Sheets, the application
accesses the following data on your behalf:
- Database schemas — table names, column names, column types,
indexes, and foreign key relationships.
- Query results — the rows and columns returned by SQL queries
that the application executes against your database.
- Google Sheets data — when you connect a Google Sheet, YourQL
requests read-only access (
spreadsheets.readonly) to the
spreadsheet you specify. It reads cell data to query it with SQL.
How data is used
- Schema and query results are sent to the large language model
(LLM) provider you configure (e.g., OpenAI, Anthropic, Ollama) as part of the
natural-language-to-SQL conversation.
- The LLM provider's privacy policy governs how it handles data you send to it.
YourQL does not add data to prompts beyond what is necessary for answering
your question.
- YourQL does not train models on your data, sell your data, or share your data
with any party other than the LLM provider you choose.
Data storage
- All data stays on your machine. YourQL stores conversation
history, database connection settings, and configuration in a local SQLite
database on your computer.
- Google OAuth tokens are stored locally on your machine
in the same local database. They are never transmitted to YourQL servers
(we do not operate any).
- You can delete all stored data by removing the application's data directory.
Google API data
YourQL's use and transfer to any other app of information received from Google
APIs will adhere to the
Google API Services User Data Policy,
including the Limited Use requirements.
- YourQL accesses Google Sheets data solely to let you query it alongside your
other data sources.
- YourQL does not access, read, or store data from any Google service beyond
the specific spreadsheets you connect.
- YourQL does not use Google data for advertising or analytics.
- YourQL does not share Google data with third parties except as directed by you
(i.e., when you send query results to your chosen LLM provider).
Third-party services
When you use YourQL, you may configure it to use third-party LLM providers
(OpenAI, Anthropic, Ollama, or custom endpoints). Data you query is sent to
these providers according to their respective privacy policies:
Your rights
Since YourQL stores all data locally on your machine, you maintain full control:
- Access: All your data is in a local SQLite file you can inspect.
- Deletion: Delete conversations, connections, or the entire
data directory at any time.
- Revocation: Revoke Google OAuth access at any time via
Google Account Permissions
or by clicking "Disconnect" in YourQL's settings.
Contact
YourQL is an open-source project maintained by Benjamin Barlow.
For privacy questions, email
yourquerylanguage@gmail.com.