DEV Community

Cover image for SW Connector 2.0.5: Adding MySQL Support Alongside PostgreSQL
vivek.ky
vivek.ky

Posted on

SW Connector 2.0.5: Adding MySQL Support Alongside PostgreSQL

I've released SW Connector 2.0.5, bringing MySQL support to Schema Weaver alongside PostgreSQL.

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

  1. MySQL support

The new MySQL adapter supports:

Schema, table and column introspection.

Database metadata and index information.

Row pagination and filtering.

Counts and distinct values.

CSV and XLSX exports.
Enter fullscreen mode Exit fullscreen mode
  1. Shared Data Explorer experience

PostgreSQL and MySQL now use the same Data Explorer grid experience.

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.

  1. Updated CLI

sw-connector is now the primary CLI command.

Existing binary names remain available to avoid breaking existing installations.

  1. Security

The existing security architecture is preserved:

Local credential handling.

Connector-enforced read-only execution.

Transient data handling.

HMAC-based audit chain.

TLS required for remote connections.
Enter fullscreen mode Exit fullscreen mode

Installation

The npm package name remains unchanged:

npm install -g @schema-weaver/pg-connector

Initialize the connector:

sw-connector init

What's supported?

SW Connector 2.0.5 currently supports:

PostgreSQL

MySQL
Enter fullscreen mode Exit fullscreen mode

MongoDB is being handled separately as part of the planned 2.1.0 document-explorer release.
What's next?

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.

Feedback from developers using PostgreSQL and MySQL in real environments is welcome.

Project links

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
Enter fullscreen mode Exit fullscreen mode

Top comments (1)

Collapse
 
robertpaschal profile image
Odinaka Robert Nnamani •

One connector for Postgres and MySQL with the same Data Explorer is a clean step. The capability-aware routing is what keeps the interface honest.