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?
- 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.
- 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.
- Updated CLI
sw-connector is now the primary CLI command.
Existing binary names remain available to avoid breaking existing installations.
- 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.
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
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

Top comments (1)
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.