<?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: vivek.ky</title>
    <description>The latest articles on DEV Community by vivek.ky (@lnxtanx).</description>
    <link>https://dev.to/lnxtanx</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%2F4025342%2Fa1b1422a-3986-4590-ad68-e7d30a28bec0.jpg</url>
      <title>DEV Community: vivek.ky</title>
      <link>https://dev.to/lnxtanx</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/lnxtanx"/>
    <language>en</language>
    <item>
      <title>SW Connector 2.0.5: Adding MySQL Support Alongside PostgreSQL</title>
      <dc:creator>vivek.ky</dc:creator>
      <pubDate>Sat, 21 Nov 2026 11:56:43 +0000</pubDate>
      <link>https://dev.to/lnxtanx/sw-connector-205-adding-mysql-support-alongside-postgresql-218m</link>
      <guid>https://dev.to/lnxtanx/sw-connector-205-adding-mysql-support-alongside-postgresql-218m</guid>
      <description>&lt;p&gt;I've released SW Connector 2.0.5, bringing MySQL support to Schema Weaver alongside PostgreSQL.&lt;/p&gt;

&lt;p&gt;The goal was to support multiple database engines through one connector architecture while maintaining a consistent experience in Schema Weaver's Data Explorer.&lt;br&gt;
What's included?&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;MySQL support&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The new MySQL adapter supports:&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Schema, table and column introspection.

Database metadata and index information.

Row pagination and filtering.

Counts and distinct values.

CSV and XLSX exports.
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;

&lt;ol&gt;
&lt;li&gt;Shared Data Explorer experience&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;PostgreSQL and MySQL now use the same Data Explorer grid experience.&lt;/p&gt;

&lt;p&gt;The connector uses capability-aware routing, so the interface exposes functionality according to what each database engine supports rather than assuming every engine has identical capabilities.&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Updated CLI&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;sw-connector is now the primary CLI command.&lt;/p&gt;

&lt;p&gt;Existing binary names remain available to avoid breaking existing installations.&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Security&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The existing security architecture is preserved:&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Local credential handling.

Connector-enforced read-only execution.

Transient data handling.

HMAC-based audit chain.

TLS required for remote connections.
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;

&lt;p&gt;Installation&lt;/p&gt;

&lt;p&gt;The npm package name remains unchanged:&lt;/p&gt;

&lt;p&gt;npm install -g @schema-weaver/pg-connector&lt;/p&gt;

&lt;p&gt;Initialize the connector:&lt;/p&gt;

&lt;p&gt;sw-connector init&lt;/p&gt;

&lt;p&gt;What's supported?&lt;/p&gt;

&lt;p&gt;SW Connector 2.0.5 currently supports:&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;PostgreSQL

MySQL
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;

&lt;p&gt;MongoDB is being handled separately as part of the planned 2.1.0 document-explorer release.&lt;br&gt;
What's next?&lt;/p&gt;

&lt;p&gt;This release is an important step toward making Schema Weaver work across different database environments without requiring a separate analytics workflow for every database engine.&lt;/p&gt;

&lt;p&gt;Feedback from developers using PostgreSQL and MySQL in real environments is welcome.&lt;/p&gt;

&lt;p&gt;Project links&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;GitHub: https://github.com/Schema-Weaver/sw-connector

npm: https://www.npmjs.com/package/@schema-weaver/pg-connector

Website: https://schemaweaver.dev

Documentation: https://docs.schemaweaver.dev
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&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%2Fyefdghgn2fand1pksej6.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%2Fyefdghgn2fand1pksej6.png" alt=" " width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;

</description>
      <category>mysql</category>
      <category>postgres</category>
      <category>devtools</category>
      <category>database</category>
    </item>
    <item>
      <title>Schema Weaver Connector V2</title>
      <dc:creator>vivek.ky</dc:creator>
      <pubDate>Thu, 29 Oct 2026 08:53:55 +0000</pubDate>
      <link>https://dev.to/lnxtanx/schema-weaver-connector-v2-4cem</link>
      <guid>https://dev.to/lnxtanx/schema-weaver-connector-v2-4cem</guid>
      <description>&lt;div class="crayons-card c-embed text-styles text-styles--secondary"&gt;
    &lt;div class="c-embed__content"&gt;
        &lt;div class="c-embed__cover"&gt;
          &lt;a href="https://schemaweaver.dev/blog/schema-weaver-connector-v2-zero-ingress-security-local-credentials-and-ast-verified-ai-analytics" class="c-link align-middle" rel="noopener noreferrer"&gt;
            &lt;img alt="" src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fercividcktdqbuiaxymm.supabase.co%2Fstorage%2Fv1%2Fobject%2Fpublic%2Fblog-media%2Fuploads%2F1793263520181-yv9xf.png" height="472" class="m-0" width="799"&gt;
          &lt;/a&gt;
        &lt;/div&gt;
      &lt;div class="c-embed__body"&gt;
        &lt;h2 class="fs-xl lh-tight"&gt;
          &lt;a href="https://schemaweaver.dev/blog/schema-weaver-connector-v2-zero-ingress-security-local-credentials-and-ast-verified-ai-analytics" rel="noopener noreferrer" class="c-link"&gt;
            Schema Weaver Connector v2: Zero-Ingress Security, Local Crede...
          &lt;/a&gt;
        &lt;/h2&gt;
          &lt;p class="truncate-at-3"&gt;
            Discover Schema Weaver Connector v2: Local Credential Boundaries, AST-verified read-only SQL gates, 0 open inbound ports, and 24/7 background daemon superv...
          &lt;/p&gt;
        &lt;div class="color-secondary fs-s flex items-center"&gt;
            &lt;img alt="favicon" class="c-embed__favicon m-0 mr-2 radius-0" src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fschemaweaver.dev%2Ffavicon.ico" width="300" height="300"&gt;
          schemaweaver.dev
        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/div&gt;
&lt;/div&gt;


</description>
      <category>ai</category>
      <category>postgres</category>
      <category>discuss</category>
      <category>opensource</category>
    </item>
    <item>
      <title>Schema weaver</title>
      <dc:creator>vivek.ky</dc:creator>
      <pubDate>Wed, 28 Oct 2026 16:37:38 +0000</pubDate>
      <link>https://dev.to/lnxtanx/i-built-an-ai-data-explorer-for-postgresql-id-love-honest-feedback-3dnl</link>
      <guid>https://dev.to/lnxtanx/i-built-an-ai-data-explorer-for-postgresql-id-love-honest-feedback-3dnl</guid>
      <description>&lt;p&gt;Hey DEV Community!&lt;/p&gt;

&lt;p&gt;I've been building &lt;strong&gt;Schema Weaver&lt;/strong&gt; Data Explorer, and I'd love to get it in front of developers who work with PostgreSQL.&lt;/p&gt;

&lt;p&gt;The idea is to make exploring database data easier, whether you're investigating an issue, looking for patterns, or trying to answer a business question.&lt;/p&gt;

&lt;p&gt;Here's what you can do with it:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Ask Resona AI questions about your data in natural language and let it investigate by executing queries.&lt;/li&gt;
&lt;li&gt;Explore tables, filter records, inspect column statistics, and turn your findings into interactive charts.&lt;/li&gt;
&lt;li&gt;Generate reports and presentations from your analysis instead of manually piecing everything together.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;There's also a local PostgreSQL connector, so you can connect databases accessible from your machine, including localhost and private-network databases. Your database credentials stay on your machine.&lt;/p&gt;

&lt;h3&gt;
  
  
  Don't have a database ready? That's fine.
&lt;/h3&gt;

&lt;p&gt;&lt;strong&gt;A demo PostgreSQL database is already connected.&lt;/strong&gt; You can open Data Explorer and start experimenting without setting up a database or installing the connector first.&lt;/p&gt;

&lt;p&gt;Try asking questions such as:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Which customers have the highest order values?&lt;/li&gt;
&lt;li&gt;Are there duplicate records or unusual values in this dataset?&lt;/li&gt;
&lt;li&gt;What trends can you find in the data?&lt;/li&gt;
&lt;li&gt;Can you visualize the results and summarize the findings?&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Use the demo to explore the features and see whether the results are actually useful to you.&lt;/p&gt;

&lt;p&gt;I'd appreciate your honest feedback.&lt;/p&gt;

&lt;p&gt;I'm particularly interested in hearing from PostgreSQL developers:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;What works well, and what feels frustrating?&lt;/li&gt;
&lt;li&gt;What would you expect a tool like this to do that it currently doesn't?&lt;/li&gt;
&lt;li&gt;Would this fit into your workflow, or would you still prefer your existing tools?&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;I'm building this to solve real problems, so specific criticism is much more useful than a simple thumbs-up.&lt;/p&gt;

&lt;p&gt;Try Schema Weaver :&lt;br&gt;
&lt;a href="https://schemaweaver.dev/" rel="noopener noreferrer"&gt;https://schemaweaver.dev/&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Thanks for checking it out!&lt;/p&gt;

&lt;h1&gt;
  
  
  showdev #postgres #ai #discuss
&lt;/h1&gt;

</description>
      <category>showdev</category>
      <category>postgres</category>
      <category>discuss</category>
      <category>ai</category>
    </item>
  </channel>
</rss>
