The latest articles on DEV Community by Ashish Srivastava (@ashish_srivastava_e6b8ecc). https://dev.to/ashish_srivastava_e6b8ecc https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3848403%2F4bc880a0-54d5-445d-bbd4-96b16db4440f.png https://dev.to/ashish_srivastava_e6b8ecc en Ashish Srivastava Fri, 10 Apr 2026 21:59:09 +0000 https://dev.to/ashish_srivastava_e6b8ecc/db-explorer-301-the-ai-first-sql-editor-youll-want-to-try-2dlm https://dev.to/ashish_srivastava_e6b8ecc/db-explorer-301-the-ai-first-sql-editor-youll-want-to-try-2dlm <p>Developers spend a surprising amount of time writing SQL, debugging queries, and navigating schemas.<br> DB Explorer 3.0.1 aims to change that.<br> This release introduces a fully schema‑aware AI SQL Generator with support for OpenAI, Claude, DeepSeek, Gemini, and custom endpoints.<br> Other highlights:</p> <ul> <li>Multi‑database support</li> <li>Execution plan viewer</li> <li>Health dashboard</li> <li>Multi‑tab SQL editor</li> <li>13 themes</li> <li>JVM‑bundled builds If you work with databases daily, this tool is worth exploring. We’re actively collecting feedback to shape the next version.</li> </ul> <p><a href="https://sourceforge.net/projects/db-explorer/" rel="noopener noreferrer">https://sourceforge.net/projects/db-explorer/</a> </p> sql database postgres dataengineering Ashish Srivastava Sat, 28 Mar 2026 23:50:50 +0000 https://dev.to/ashish_srivastava_e6b8ecc/i-built-a-free-desktop-sql-client-with-a-live-database-health-dashboard-16om https://dev.to/ashish_srivastava_e6b8ecc/i-built-a-free-desktop-sql-client-with-a-live-database-health-dashboard-16om <h2> What is DB Explorer? </h2> <p>DB Explorer is a free, open desktop database client built in Java. It supports <br> PostgreSQL, MySQL/MariaDB, Oracle, SQL Server, SQLite, and AWS DynamoDB — all from <br> one tool, with no subscription, no telemetry, and no account required.</p> <h2> What's new in v2.1 </h2> <p>The big addition is a <strong>live Database Health Dashboard</strong>. When you enable it for a <br> connection, it opens a dedicated background JDBC connection (separate from your <br> query connection) and polls your database's own system views on a configurable <br> interval (5–30 seconds).</p> <p>What it shows:</p> <ul> <li> <strong>Active sessions</strong> — pulled from <code>pg_stat_activity</code>, <code>SHOW PROCESSLIST</code>, <code>v$session</code>, <code>sys.dm_exec_sessions</code> depending on your DB. Your own session is highlighted.</li> <li> <strong>Server stats</strong> — cache hit ratios, commits, rollbacks, wait events</li> <li> <strong>Connection health</strong> — green/red indicator, reconnect count, last check timestamp</li> <li> <strong>JVM resources</strong> — heap usage bar (amber &gt;70%, red &gt;90%), thread count, GC stats</li> <li> <strong>SQL warnings log</strong> — circular buffer of the last 100 warnings</li> </ul> <p>The dashboard is opt-in and disabled by default. Stopping it immediately closes the <br> background thread and JDBC connection — no background activity unless you turn it on.</p> <h2> Download </h2> <p><a href="https://sourceforge.net/projects/db-explorer/" rel="noopener noreferrer">https://sourceforge.net/projects/db-explorer/</a></p> <p>It's a single fat JAR — just <code>java -jar db-explorer-2.1.jar</code> and you're running.</p> <p>Feedback welcome, especially from Oracle and SQL Server users.</p> database java showdev sql