@azimutt/connector-mysql

MySQL connector

This library allows to connect to MySQL, extract its schema and more...

It lists all schemas, tables, columns, relations and types and format them in a JSON Schema.

This library is made by Azimutt to allow people to explore their MySQL database. It's accessible through the Desktop app (soon), the CLI or even the website using the gateway server.

Feel free to use it and even submit PR to improve it:

• improve MySQL queries (look at getSchema function)

Set up a sample MySQL database

• Go on https://www.freemysqlhosting.net and click on "Start my Free Account"
• Follow the onboarding:
  • Reset password and login
  • Click on "MySQL Hosting" in to top menu
  • Create your database
• Get your credentials by email and build the url like: mysql://<user>:<pass>@<host>:<port>/<db> ("Server" is the host, "Name" is the db name)
• Load data in your instance, if you don't have, you can use schemas from Prisma schema examples

Publish

• update package.json version
• update lib versions (npm run update + manual) & run npm install
• test with npm run dry-publish and check azimutt-connector-mysql-x.y.z.tgz content
• launch npm publish --access public

View it on npm.