All integrations
Databases
MySQL / MariaDB
Browse tables and run read-only SQL on a MySQL or MariaDB database. Optionally list your users table on Users.
What you see
Databases
On the Data page as soon as MySQL / MariaDB is connected.Sign-in, optional
On the Users page once you fill in Users table.
How to connect
Paste a key
mysql://user:password@host:3306/database. Remote hosts get TLS; add ?ssl-mode=VERIFY_IDENTITY to check the certificate, or ?ssl-mode=DISABLED for a server without TLS. Use a user that can only read, plus UPDATE on the banned column if you want bans. Get a key The key is checked against MySQL / MariaDB before it’s saved, then sealed so only the broker that calls MySQL / MariaDB can open it.From a terminal
The CLI asks for the same key at a hidden prompt, so an agent running it never sees the key.$ npx baseboard-cli connect mysql --project k57abc
Settings
- Users tableoptional
- Name your users table to list its rows as accounts on Users.For example
users - Id columnoptional
- For example
id - Email columnoptional
- For example
email - Created-at columnoptional
- For example
created_at - Last sign-in columnoptional
- For example
last_sign_in_at - Banned columnoptional
- A boolean column. With it, bans can be requested from Users.For example
banned
Connect MySQL / MariaDB and the rest of your stack in one place.
Free covers one project with three connections. Everyone starts read-only.