Atlas has a Cloud platform that offers an Explore feature without having to sign up. The Explore feature allows you to generate an Entity Relationship Diagram (ERD) from your database by either manually typing in your schema, or importing from an existing database.
Due to the fact that this is a web-based platform, connecting to your local database won't work. There are two quick and easy ways to get around this and still get the benefits of this feature:
- Inspect your database with Atlas and copy it to your clipboard in a single command.
ngrokto create a public URL for your database.
Inspecting with Atlas and copying to clipboard
One of Atlas's main features is inspection. Once downloading Atlas, you can easily use the inspect command to automatically generate an HCL schema from your database.
In the Cloud platform, in order to generate an ERD from a local database, you can provide the HCL schema itself. To quickly do so, run the inspect command and pipe the result to copy the schema to your clipboard.
Depending on your operating system, the command will be:
atlas schema inspect -u "mysql://root:pass@localhost:3306/db_name" | pbcopy
atlas schema inspect -u "mysql://root:pass@localhost:3306/db_name" | clip
Linux users, first follow this tutorial
on how to install
pbcopy, and then you can use the same command as macOS. Note that this will not work on all Linux
environments, so be sure to find a tutorial that fits yours.
Paste the schema in the Cloud and click visualize.
Connecting to a local database with ngrok
ngrok is a popular tool that allows developers to securely expose a local development server to the internet with a public URL. This can be useful for testing webhooks, or for allowing other people to access your local development environment for collaboration or testing purposes.
We will learn how to connect to a local database using ngrok.
Begin by installing ngrok on your local machine.
Start a TCP tunnel
Next, we will start a TCP tunnel, which is where we will channel our traffic to. In our case, we will channel the port on which our database is running.
To do so, use the command
ngrok tcp with the relevant port that our service is running on.
For example, if we have a MySQL instance running on port 3306 we will run the following:
ngrok tcp 3306
Now ngrok will provide us with a public URL that we can use to access our local database.
In this example, we can see that ngrok is running our MySQL instance on the URL
We can connect to our local database with a database URL that looks something like:
Make sure to remove the 'tcp://' from the URL and write in your local username and password to access the database.
Open the Explore feature and click on
A modal will open up where we can enter in our database URL.
Paste in the database URL we just created and click import.
In this guide we showed how to easily inspect a database schema using Atlas or ngrok to make using the Explore feature quick and easy when importing a schema from a local database.
Have questions? Feedback? Feel free to reach out on our Discord server.