Skip to main content

​
Prerequisites

​
Connect PlanetScale to VexiData

1

Create a password for VexiData

PlanetScale uses generated passwords for each connection. Create a dedicated one for VexiData:
  1. Log in to your PlanetScale Dashboard
  2. Select the database you want to connect
  3. Click Connect
  4. Select the Branch you want to connect to (e.g., main)
  5. Click Create password
  6. Choose General as the connection type
  7. Copy the credentials shown:
ParameterExample
Hostaws.connect.psdb.cloud
Port3306
Databasemy_database
Usernameabc123def456gh
Passwordpscale_pw_aBcDeFgHiJkLmNoPqRsTuVwXyZ
The password is only shown once when created. Save it immediately. If you lose it, you’ll need to create a new password.
2

Add the connection in VexiData

  1. Go to Data Sources in VexiData
  2. Click MySQL to open the connection form
  3. Fill in the details:
FieldValue
Display NameA name to identify this connection (e.g., “PlanetScale Production”)
Hostaws.connect.psdb.cloud (or your regional host)
Port3306
DatabaseYour database name
UsernameYour PlanetScale username
PasswordYour PlanetScale password (starts with pscale_pw_)
3

Test and save

Click Test & Save Connection. VexiData will verify it can reach your database. Once connected, your schema will be analyzed automatically.

​
PlanetScale branches

PlanetScale supports database branching — each branch has its own connection credentials. When connecting to VexiData, make sure you select the correct branch (usually main for production data). If you want to connect multiple branches (e.g., production and development), create a separate data source in VexiData for each one. You’ll need to create a separate password for each branch in PlanetScale.

​
Troubleshooting

  • PlanetScale requires SSL for all connections. VexiData handles this automatically, but if you see timeout errors, verify the host and port are correct
  • Check that your PlanetScale database is not in a sleeping state (free-tier databases sleep after inactivity)
  • PlanetScale passwords start with pscale_pw_. Make sure you copied the full password including this prefix
  • Passwords are only shown once when created. If you’ve lost it, create a new password from the PlanetScale dashboard
  • Verify you’re connecting to the correct branch — each branch has its own credentials
  • Check that you selected the correct branch when creating the password. Your main branch has your production schema, while development branches may have different tables
  • Confirm the database name matches exactly what’s shown in PlanetScale
  • PlanetScale runs on Vitess, which has some differences from standard MySQL. Most standard queries work normally, but certain advanced features (like foreign key constraints in some configurations) may behave differently