{"id":43759,"library":"repzo-sql-connector","title":"Repzo SQL Connector","description":"Repzo SQL Connector (v1.1.38) enables seamless data synchronization between Repzo CRM and SQL databases, supporting reporting and analytics with platforms like Microsoft Power BI. It provides a TypeScript SDK with connection management, schema mapping, and data export utilities. Actively maintained with frequent releases, it is designed for ETL workflows. Ship with TypeScript types and ESM/CJS support.","status":"active","version":"1.1.38","language":"javascript","source_language":"en","source_url":"ssh://git@github.com/Repzo/sql-connector","tags":["javascript","typescript"],"install":[{"cmd":"npm install repzo-sql-connector","lang":"bash","label":"npm"},{"cmd":"yarn add repzo-sql-connector","lang":"bash","label":"yarn"},{"cmd":"pnpm add repzo-sql-connector","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"MySQL database driver for SQL connections","package":"mysql2","optional":false},{"reason":"MSSQL database driver for SQL Server connections","package":"tedious","optional":true}],"imports":[{"note":"ESM default; CommonJS users must use destructured require.","wrong":"const SqlConnector = require('repzo-sql-connector').SqlConnector","symbol":"SqlConnector","correct":"import { SqlConnector } from 'repzo-sql-connector'"},{"note":"Config is a TypeScript type, export named as type. Use import type for clarity.","wrong":"import { Config } from 'repzo-sql-connector'","symbol":"Config","correct":"import type { Config } from 'repzo-sql-connector'"},{"note":"The function is named connect, not Connection. Connection is a class used internally.","wrong":"import { Connection } from 'repzo-sql-connector'","symbol":"connect","correct":"import { connect } from 'repzo-sql-connector'"},{"note":"Client is a named export. There is no default export.","wrong":"const Client = require('repzo-sql-connector').default","symbol":"Client","correct":"import { Client } from 'repzo-sql-connector'"}],"quickstart":{"code":"import { SqlConnector } from 'repzo-sql-connector';\n\nconst connector = new SqlConnector({\n  host: process.env.DB_HOST ?? 'localhost',\n  port: parseInt(process.env.DB_PORT ?? '3306'),\n  database: process.env.DB_NAME ?? 'repzo',\n  user: process.env.DB_USER ?? 'root',\n  password: process.env.DB_PASSWORD ?? '',\n  dialect: 'mysql',\n});\n\nconnector.connect()\n  .then(() => connector.syncAll())\n  .then(() => console.log('Sync complete'))\n  .catch(console.error);","lang":"typescript","description":"Initializes a MySQL connection, connects, and triggers full data sync."},"warnings":[{"fix":"Update to object-based config: new SqlConnector({ host, port, ... }).","message":"v1.0.0 changed configuration parameter order; existing code using positional arguments will break.","severity":"breaking","affected_versions":"<1.0.0"},{"fix":"Use connector.syncTables(['table1', 'table2']).","message":"The syncAll method is deprecated in v1.1.0 in favor of syncTables().","severity":"deprecated","affected_versions":">=1.1.0"},{"fix":"Update Node.js to v16+ and install tedious@15.","message":"When using MSSQL (tedious), the package requires tedious v15+ and Node.js 16+. Older Node.js versions will cause runtime errors.","severity":"gotcha","affected_versions":">=1.1.0"},{"fix":"Consume the returned stream via pipeline() or response.pipe().","message":"In v1.2.0, the export method previously returning a Promise was changed to return readable streams for large datasets.","severity":"breaking","affected_versions":">=1.2.0"},{"fix":"Use import { SqlConnector } from 'repzo-sql-connector' instead.","message":"The default export (SqlConnector default) was removed in v1.0.0; only named exports are available.","severity":"deprecated","affected_versions":">=1.0.0"},{"fix":"Use other connectors for PostgreSQL or SQLite.","message":"The package does not support SQLite or PostgreSQL; only MySQL and MSSQL are supported.","severity":"gotcha","affected_versions":"all"}],"env_vars":null,"search_vec":"'activ':42 'analyt':21 'bi':27 'connect':34 'connector':3,6 'crm':14 'data':10,39 'databas':17 'design':49 'enabl':8 'esm/cjs':58 'etl':51 'export':40 'frequent':45 'javascript':60 'like':24 'maintain':43 'manag':35 'map':37 'microsoft':25 'platform':23 'power':26 'provid':29 'releas':46 'report':19 'repzo':1,4,13 'schema':36 'sdk':32 'seamless':9 'ship':53 'sql':2,5,16 'support':18,59 'synchron':11 'type':56 'typescript':31,55,61 'util':41 'v1.1.38':7 'workflow':52","created_at":"2026-06-05T17:01:20.416638+00:00","updated_at":"2026-06-05T17:01:20.416638+00:00","problems":[{"fix":"Run npm install repzo-sql-connector and ensure import uses correct case.","cause":"Package not installed or wrong import path.","error":"Error: Cannot find module 'repzo-sql-connector'"},{"fix":"Use connector.syncTables() instead.","cause":"syncAll was removed in v1.1.0.","error":"TypeError: connector.syncAll is not a function"},{"fix":"Start MySQL server or update configuration in connector constructor.","cause":"MySQL server not running or wrong host/port.","error":"Error: connect ECONNREFUSED 127.0.0.1:3306"},{"fix":"Check user and password in the connector config.","cause":"Invalid credentials for MSSQL.","error":"Error: ConnectionError: Login failed for user '...'"},{"fix":"Update to object-based config (see breaking change warning).","cause":"Using array-based parameters before v1.0.0.","error":"TypeError: (destructured parameter) is not iterable"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/Repzo/sql-connector#readme","github":"ssh://git@github.com/Repzo/sql-connector","docs":null,"changelog":null,"pypi":null,"npm":"repzo-sql-connector","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database","crm"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}