Connect your PlanetScale MySQL-compatible database to VexiData for natural language querying and dashboard creation. Connection takes about 2 minutes.

Connect PlanetScale to VexiData

Click to play video

Prerequisites

A VexiData account (free tier available)Create account
A PlanetScale account with a databasePlanetScale
Access to your PlanetScale dashboard

Connection Steps#

Access PlanetScale Dashboard

Create a Password

PlanetScale uses passwords (credentials) for database access:

1. Go to Settings > Passwords

2. Click New password

3. Select your branch (usually main)

4. Choose the appropriate role (e.g., reader for read-only access)

5. Click Create password

Get Connection Details

After creating a password, PlanetScale will show you the connection details:

• Host: Your database host (e.g., aws.connect.psdb.cloud)

• Port: 3306

• Database: Your database name

• Username: The generated username

• Password: The generated password

Important: Copy the password immediately as it won't be shown again.

Connect in VexiData

In VexiData, go to Data Sources from the menu, then select MySQL under the Add New Data Source section.

text

Display Name:    My PlanetScale Database
Host:            aws.connect.psdb.cloud
Port:            3306
Database:        your_database_name
Username:        your_planetscale_username
Password:        your_planetscale_password

Test and Save

Click Test & Save Connection. Once successful, you can start querying your PlanetScale data!

Branch-Based Development

PlanetScale uses branches for database development. Make sure you're connecting to the correct branch (usually main for production data).

Search Documentation