YourQL

Overview

YourQL is a desktop app that turns plain-English database questions into SQL queries, tables, charts, and summaries. It suits people who want AI-assisted, read-only exploration across databases and spreadsheets, with a choice of language-model provider.

Its broad connections and local control make it a capable free option for investigation and reporting. The project is still a work in progress, and using an AI model gives that model access to configured databases, so careful setup matters.

Key features

YourQL reads a database schema, sends a prompt to the selected model, and executes the SQL it generates. When a query errors, the app can send the error back to the model for correction and another attempt. That loop can help users explore without writing every query themselves, but generated results still warrant review before they inform important decisions.

Supported sources include MySQL, MariaDB, PostgreSQL, SQLite, SQL Server, Snowflake, BigQuery, Redshift, CSV, Excel, and Google Sheets. That range is useful for teams working across databases and tabular files. Exploration can use strict, moderate, or relaxed safety modes; the maker says queries are restricted to SELECT statements and write operations are forbidden.

Automatic charts and summaries make returned results easier to scan, and conversations can be exported as PDF, HTML, or Markdown. Database-specific prompts and business rules, table and column descriptions, and reusable Markdown skills let users add context to conversations. These controls are most valuable when database names or business terms need explanation to the model.

YourQL supports OpenAI, Anthropic Claude, Ollama, and custom OpenAI-compatible HTTP endpoints. Conversations, settings, and connection details are stored locally. The maker says there is no telemetry or analytics, and that the app communicates only with configured model endpoints and connected databases. Provider keys and database credentials are stored in the local database and sent only to the configured provider or database as applicable. Local storage does not remove the central trade-off: a configured model gets access to connected databases.

Pricing

YourQL is free: the Free plan costs nothing and includes the desktop application. It has no paid tier described here, making it accessible for personal exploration without a subscription. Its work-in-progress status is the principal compromise; users seeking a mature, production-critical workflow should weigh that carefully.

Platforms

YourQL is available for Linux, macOS, and Windows. It is a self-hosted desktop application, rather than a web service.

Who it's for

YourQL is a good fit for analysts and database users who want to ask questions in everyday language, inspect read-only results, and visualize or export them. It also suits users who want to select their own model provider, including a local Ollama setup. It is a poor fit for anyone needing write operations, or for sensitive data environments that cannot grant a configured model access to connected databases.

Pros and cons

• Broad source support: connects to eight named database systems as well as CSV, Excel, and Google Sheets, which helps when analysis spans different formats.
• Provider choice and local settings: supports hosted and local model options while keeping conversations, settings, and connection details on the device.
• Read-only by design: configurable safety modes and SELECT-only queries reduce the risk of accidental data changes, though the model still receives database access.
• Work in progress: the project status makes it less suitable where users need a settled, dependable tool for critical workflows.

Alternatives

Browse AI Database Assistants for more options in this category.

• DataZen is another free Linux, macOS, and Windows option; its GPLv3 license, no-account setup, and BYO AI provider suit users who prioritize those terms.
• Insight O' Mate has a free plan capped at 20 database analyses per day, one founder, and one database; its $29 a month Pro plan adds unlimited queries, priority queue, and advanced export. Choose it if those stated limits and Pro features better match your workload.
• Outerbase AI offers a free tier with up to five users, one base, 10 EZQL queries per month, three saved queries, and one dashboard for transactional databases. It is worth considering if that team-oriented allowance and its API, web, self-hosted, or desktop platform options fit your needs.
• Florentine.ai is a web and API option with a free plan billed forever, covering one database, five active collections or tables, 500 requests per month, MongoDB and MySQL, plus MCP Server and API. Choose it if that service model and its stated database coverage suit you.
• DataLine is presented as an open-source project under GPL-3.0 and spans Linux, macOS, Windows, web, and self-hosted platforms; consider it if open-source licensing is a priority.
• DBQuill is a free, open-source, source-first Windows desktop app, a narrower platform choice for users who want that approach.
• Wren AI offers an open-source context engine for individual developers through CLI and MCP without a UI, so it is an alternative for developers comfortable working without a graphical interface.
• Kyligence is a paid option with a free trial for readers considering a different product.

Verdict

Choose YourQL if you want a free desktop tool for natural-language, read-only database exploration, broad source support, and flexible model choice. Its charts, exports, and local settings strengthen that case. Look elsewhere if work-in-progress software is unsuitable or your data cannot be exposed to the configured model.