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)
- 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
- update
package.json
version - update lib versions (
npm run update
+ manual) & runnpm install
- test with
npm run dry-publish
and checkazimutt-connector-mysql-x.y.z.tgz
content - launch
npm publish --access public
View it on npm.