<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Mirinai</title>
    <description>The latest articles on DEV Community by Mirinai (@mirinai_ai).</description>
    <link>https://dev.to/mirinai_ai</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4223572%2Ff7c53fd0-4fe5-4568-9df1-41fdc076ae0f.png</url>
      <title>DEV Community: Mirinai</title>
      <link>https://dev.to/mirinai_ai</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/mirinai_ai"/>
    <language>en</language>
    <item>
      <title>I built a Windows SQL client where an LLM drafts the query and you stay in control</title>
      <dc:creator>Mirinai</dc:creator>
      <pubDate>Tue, 03 Nov 2026 06:30:02 +0000</pubDate>
      <link>https://dev.to/mirinai_ai/i-built-a-windows-sql-client-where-an-llm-drafts-the-query-and-you-stay-in-control-1j3i</link>
      <guid>https://dev.to/mirinai_ai/i-built-a-windows-sql-client-where-an-llm-drafts-the-query-and-you-stay-in-control-1j3i</guid>
      <description>&lt;p&gt;&lt;em&gt;Disclosure: I work at Mirinai and built this app. This post was drafted with the help of AI and reviewed by me.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Letting an LLM near a database worries me in two ways: what leaves my machine, and what happens if the generated SQL is wrong. I built Chat DB Manager, a Windows desktop database client, around those two questions.&lt;/p&gt;

&lt;p&gt;You ask a question in plain language and the app fills the editor with SQL for the connected DBMS. Nothing runs until you read it and press Run.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F9a16ru7nnfn7l2m0htxx.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F9a16ru7nnfn7l2m0htxx.png" alt="Chat DB Manager main screen: chat, SQL card, editor and result grid" width="800" height="502"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  What goes to the LLM
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Default mode (SQL Helper)&lt;/strong&gt; sends the schema in a compact notation (tables, columns, types, keys, comments, indexes), not table rows. Conversation history, files you attach, and the DB error text on auto-repair are also sent. Asking for an execution plan explanation sends the SQL and the plan. Sample values of code-like columns are sent only if you turn that on (off by default).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Agent mode&lt;/strong&gt; runs read queries itself and reads the rows, so it needs explicit consent per recipient company. Switching provider resets it to SQL Helper.&lt;/li&gt;
&lt;li&gt;With a local model behind an OpenAI-compatible URL (Ollama, LM Studio, vLLM), LLM requests go only to that URL.&lt;/li&gt;
&lt;li&gt;No telemetry. The app only contacts your LLM provider and our server for update checks.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What happens before SQL runs
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Risk is decided by the app parsing the SQL, not by the model's label. A script is judged by its worst statement, so &lt;code&gt;SELECT 1; DROP TABLE t&lt;/code&gt; is not a SELECT.&lt;/li&gt;
&lt;li&gt;Read-only connections refuse anything but SELECT.&lt;/li&gt;
&lt;li&gt;Writes run in an open transaction. You see the affected row count and commit or roll back. No answer in 2 minutes means rollback.&lt;/li&gt;
&lt;li&gt;DDL and UPDATE/DELETE without WHERE need an extra confirmation, plus a checkbox on connections tagged prod.&lt;/li&gt;
&lt;li&gt;Agent reads run in a read-only transaction and are rolled back (SQL Server and SAP HANA get rollback only).&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Read-only is an app-level guard. It cannot catch &lt;code&gt;SELECT some_writing_function()&lt;/code&gt;, so please use a read-only DB account for production.&lt;/p&gt;

&lt;h2&gt;
  
  
  Supported
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;DBMS: PostgreSQL, MySQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP HANA&lt;/li&gt;
&lt;li&gt;LLMs: Anthropic Claude, OpenAI, Google Gemini, OpenRouter, any OpenAI-compatible endpoint (Ollama, LM Studio, vLLM, Azure)&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Limits
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Windows x64 only (Electron). No macOS or Linux build. I tested it on Windows 11 Home 26H2.&lt;/li&gt;
&lt;li&gt;The installer (~143 MB) is not code-signed, so SmartScreen will likely warn you. It installs per user without admin rights, and the SHA-256 is on the download page.&lt;/li&gt;
&lt;li&gt;No account or sign-up. Bring your own LLM API key or a local endpoint.&lt;/li&gt;
&lt;li&gt;Free for now. The source code is not public.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you have no test database, a single SQLite file is enough to try the main flow.&lt;/p&gt;

&lt;h2&gt;
  
  
  Feedback I would like
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Which databases would you want next?&lt;/li&gt;
&lt;li&gt;Is the line between "schema only" and "schema plus rows with consent" in the right place?&lt;/li&gt;
&lt;li&gt;What other guard would you need before letting a tool like this near a production database?&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Download and details: &lt;a href="https://www.mirinai.com/chatdbmanager/" rel="noopener noreferrer"&gt;https://www.mirinai.com/chatdbmanager/&lt;/a&gt;&lt;br&gt;
Contact: &lt;a href="mailto:mirinai.help@mirinai.com"&gt;mirinai.help@mirinai.com&lt;/a&gt;&lt;/p&gt;

</description>
      <category>showdev</category>
      <category>sql</category>
      <category>database</category>
      <category>abotwrotethis</category>
    </item>
  </channel>
</rss>
