u/Still-Trainer-7395 — reddlx

When you’re learning SQL, do you want the tool to fix your query or teach you why it failed?

I’m curious what actually helps people learn faster.

If a query fails, would you rather just get corrected SQL, or see the original database error, exactly where it failed, an explanation of why, and then a suggested fix you can review?

I feel like automatically fixing everything can be useful, but it can also make it harder to actually learn what went wrong.

reddit.com

u/Still-Trainer-7395 — 1 day ago

▲ 0 r/sqlite

What SQLite GUI features should never be behind a paywall?

There are a lot of SQLite clients out there, from very simple viewers to full database tools, but I’m curious where people here draw the line between “basic functionality” and something worth paying for.

Things like editing data, multiple databases/connections, import/export, backups, schema tools, autocomplete, query history, etc.

Which features do you think should just be included for free in a good SQLite client?

And what would you actually be happy to pay for?

reddit.com

u/Still-Trainer-7395 — 1 day ago

▲ 17 r/mariadb

What do you think a good MariaDB client should include by default in 2026?

Not asking about exotic enterprise stuff — just the things you actually expect to have without paying extra.

For me that would be things like SSH, backups/restores, data editing, import/export, monitoring, schema tools, autocomplete, multiple connections, etc.

What do you consider basic functionality nowadays, and what would you actually be willing to pay for?

reddit.com

u/Still-Trainer-7395 — 1 day ago

▲ 0 r/Database

What features in database clients are still paywalled that you think should just be free?

I’m curious where people draw the line nowadays.

Things like multiple connections, data editing, import/export, backups, schema compare, monitoring, SSH, advanced autocomplete, etc. — which of these do you think should just be standard functionality in a database client?

And what actually feels fair to charge for?

reddit.com

u/Still-Trainer-7395 — 1 day ago

▲ 10 r/SQL

What SQL client has the best formatter if you’re picky about SQL style?

I’ve found that most formatters are configurable up to a point, but eventually you’re still forced into their idea of what “well formatted SQL” looks like.

Do you know any client where you can really personalize how SELECTs, INSERTs, UPDATEs and DELETEs are formatted?

Or do you also miss having a formatter that actually adapts to your preferred SQL style rather than the other way around?

reddit.com

u/Still-Trainer-7395 — 1 day ago

▲ 0 r/SQL

What do you wish your SQL client did when a query fails?

Most SQL clients basically give you the database error and leave you there.

When a query fails, what would actually help you most? Better error highlighting? An explanation in plain English? A suggested fix? Showing the corrected SQL?

Lately I’ve been thinking a lot about how much help is useful before a tool starts doing too much for you.

Curious what people here actually want from their SQL client.

reddit.com

u/Still-Trainer-7395 — 3 days ago

▲ 6 r/mysql

What actually makes you switch MySQL clients?

I keep seeing people complain about Workbench, DBeaver, TablePlus, etc. but still use the same client for years 😅

For people working with MySQL regularly, what would actually make you switch?

Speed? Better tabs/workspaces? Safer production workflows? Better autocomplete? AI that helps with SQL? Something else?

I’m building a database client myself, so I’m genuinely curious what the real deal-breakers are.

reddit.com

u/Still-Trainer-7395 — 3 days ago

▲ 6 r/mariadb+1 crossposts

LakeDB is now listed on the MariaDB Server Ecosystem Hub 🎉

Small milestone but this made me pretty happy 😄

LakeDB has been added to the MariaDB Server Ecosystem Hub under database management tools.

I started building it around MySQL/MariaDB workflows and it has since grown into a multi-database client with SQLite too, so it's pretty cool seeing it listed there.

Still a lot to improve, but thanks to everyone who has tested it or given feedback.

https://ecohub.mariadb.org/database-management/lakedb

u/Still-Trainer-7395 — 5 days ago

▲ 5 r/sqlite

I added first-class SQLite support to my multi-database desktop client

I’ve been building LakeDB, a local-first, multi-database desktop client currently supporting SQLite, MySQL and MariaDB.

Beta 5.1 adds SQLite as a first-class connection rather than treating it as a simplified version of a server database.

The current SQLite workflow includes:

- Opening `.db`, `.sqlite` and `.sqlite3` files directly

- Browsing tables, views, triggers, indexes and foreign keys

- Multiple connections and independent SQL/table tabs

- Row editing when a stable identity is available

- Explicit transactions and query cancellation

- `EXPLAIN QUERY PLAN`

- SQLite-aware SQL diagnostics

- Reviewable AI-assisted query correction

The AI part is optional and deliberately kept under the user’s control. It can explain a SQL error, use the available schema context and propose a corrected query, but the SQL is always shown for review. Nothing is applied or executed automatically.

The screenshot shows two local SQLite databases open alongside MySQL and MariaDB connections, with an actual SQLite query and its results. Each connection preserves its own tabs and working context.

LakeDB also hides server-only tools when SQLite is active instead of pretending every database engine supports the same operations.

Disclosure: I’m the developer of LakeDB.

I’d be interested to know which SQLite-specific cases you would test next. STRICT tables, WITHOUT ROWID, generated columns, WAL mode, ATTACH, virtual tables, or something else?

https://github.com/DavLagoHern/LakeDB

u/Still-Trainer-7395 — 10 days ago

▲ 0 r/learnSQL

Would you use AI to learn SQL?

While working on an AI feature for a SQL client, I started wondering where AI is actually most useful.

Not to replace learning SQL—but to help people understand it.

For example, instead of only generating a query, an AI could:

- Explain why it chose that query.
- Suggest a better alternative.
- Point out potential mistakes.
- Explain JOINs, GROUP BY, or subqueries in plain English.
- Help debug errors without just giving the answer.

So I’m curious…

If you’re learning SQL, would you use an AI assistant?

If yes, what would you expect it to do?

If no, what would make you avoid it?

reddit.com

u/Still-Trainer-7395 — 20 days ago

▲ 0 r/mysql

What would make you trust AI-generated SQL for MySQL?

While working on an AI feature for a MySQL client, I found myself thinking about one question:

What would actually make you trust AI-generated SQL against a real MySQL database?

Generating a query isn’t the hard part anymore.

The hard part is knowing when it’s safe to run.

If an AI suggested a query for your MySQL database, what safeguards would you expect before clicking Execute?

Some ideas I’ve been considering:

- Review the generated SQL before execution.
- Explain why that query was generated.
- Show the estimated execution plan (EXPLAIN).
- Estimate how many rows will be affected.
- Warn about full table scans or missing indexes.
- Flag potentially destructive operations (UPDATE, DELETE, DROP, etc.).
- Recommend wrapping changes in a transaction when possible.

What’s the one feature or safeguard that would make you trust AI-generated SQL more?

Or is this something you’d never feel comfortable using on a real database?

reddit.com

u/Still-Trainer-7395 — 20 days ago

▲ 5 r/DatabaseAdministators+4 crossposts

I’m building a free MySQL/MariaDB client for Windows, and Beta 4 adds a database-aware SQL AI Agent

Hi everyone! I’m the developer of LakeDB, a free and open-source desktop client for MySQL and MariaDB.

I started building it to make working across development, staging and production databases clearer and safer. It includes:

Independent connection workspaces
SQL editor with schema-aware autocomplete
Table browsing and controlled data editing
Query history, EXPLAIN and result filtering
SSH and SSL connections
Backup, restore, comparison and migration tools

The biggest addition in Beta 4 is QuerIA Agent Mode.

You can describe the result you need, and the agent investigates the available schema before proposing SQL. It can inspect tables, columns, relationships and indexes, then create a reviewable query involving multiple tables or databases.

LakeDB also shows the selected tables, index information and EXPLAIN validation. Nothing is executed automatically: the generated SQL remains visible and editable, and you explicitly decide whether to run it.

LakeDB is available for Windows x64 as an installer or portable executable:
https://davlagohern.github.io/LakeDB/

This is still a public beta and the Windows packages are not code-signed yet, so SmartScreen may display a first-launch warning. Downloads and SHA-256 checksums are published in the official GitHub repository.

I’d really appreciate feedback on the Windows experience, Agent Mode and anything that feels missing from your normal database workflow.

u/Still-Trainer-7395 — 5 days ago

▲ 4 r/MacOSApps+1 crossposts

I built a local-first MySQL/MariaDB client — Beta 3.0 adds reviewable, schema-aware AI

I have been building LakeDB, a cross-platform desktop SQL client for MySQL and MariaDB.

It started as a way to manage development, staging and production databases without losing track of the active environment. It now includes:

- independent multi-connection workspaces;

- persistent SQL tabs and database objects;

- schema-aware autocomplete with aliases, primary keys and indexes;

- table editing, query history, EXPLAIN and server monitoring;

- SSH/SSL connections, backup, restore, compare and migration tools.

Beta 3.0 introduces QuerIA.

Write a request in natural language, review the SQL LakeDB prepares, and decide whether to run it through the normal local results panel.

QuerIA understands the active schema and can prepare SELECT, INSERT, UPDATE, DELETE, CREATE TABLE and ALTER TABLE statements. Nothing executes automatically.

It is disabled by default and requires explicit opt-in. Credentials, table rows and query results are never sent, and questions or generated SQL are not stored.

LakeDB is currently free and available for macOS Apple Silicon, Windows x64 and Linux x64.

Website, screenshots and downloads:

https://davlagohern.github.io/LakeDB/

What would you need before trusting AI-prepared SQL in your database workflow?

u/Still-Trainer-7395 — 25 days ago

▲ 11 r/DatabaseAdministators+4 crossposts

[MySQL/MariaDB] I built a desktop SQL client around multi-connection workflows

I work with MySQL and MariaDB databases every day, usually with several environments open simultaneously and tables containing millions of rows.

I built LakeDB because I wanted a SQL client where each connection maintained its own queries, open tables, selected database and workspace state, without turning the interface into an enormous collection of panels.

The current 0.11 beta includes:

- Independent multi-connection workspaces

- Schema-aware autocomplete for databases, tables and columns

- Alias detection, including suggestions such as t2.column

- Primary key and index information in autocomplete

- SQL formatting for queries and stored procedures

- EXPLAIN support

- Table filtering and controlled cell editing

- Empty result grids that preserve column metadata

- Procedure, function, event and trigger inspection

- Visual schema editing with generated SQL preview

- CSV, JSON, Excel-compatible and SQL exports