Skip to Content
Enderdash

Browse and edit databases

Add a database source on the agent, inspect tables, change rows carefully, and run raw SQL when you have the grant.

The Databases panel reads databases through the agent. The agent opens the connection from its own host, so the database does not need to accept connections from your browser.

Before you begin

You need:

  • An agent that reports database support, on an online server.
  • The database management plan feature.
  • Server access that includes the database operations you need. Members need a scoped grant for reading, for writing, and for raw SQL separately.

Back up a database before you change it. Enderdash does not keep a copy of rows that you edit or delete.

Add a source

A source is one database that the agent can open. The panel supports SQLite, MySQL, and PostgreSQL.

The agent finds SQLite files inside the server directory on its own. These appear as automatic sources. You cannot delete an automatic source from the panel.

To add another source:

  1. Open Databases and choose Add source.
  2. Select the Data source type.
  3. Enter a Label that identifies the database to your team.
  4. For SQLite, enter the File path. A relative path starts at the server directory.
  5. For MySQL or PostgreSQL, enter the host, database, username, and password. The host must be reachable from the agent's host.
  6. Choose Add source in the form and make sure that the source shows as healthy.

The agent stores the source and its credentials in its own local state, encrypted. Use a database account with the least privilege that the task needs. A read-only account is the safest way to make a source read-only.

Inspect a table

  1. Select the source, then a table.
  2. Use the structure view to read columns, types, and indexes.
  3. Browse rows. Change Page size or filter the table list when the database is large.

Check the source label and table name before you rely on a value. Two servers can have tables with the same name.

Change rows

You can add a row, duplicate a row, edit a cell, and delete matching rows when your access allows writes. Before you save:

  1. Make sure that the selected source belongs to the intended server.
  2. To delete, open the row's menu and choose Delete row. Read the Delete matching rows? confirmation before you choose Delete rows. The action applies to every row that matches.
  3. After the change, reload the table and make sure that the result is what you expected.

The application that owns the database can cache its data. A plugin may not see your change until it reloads, or it may overwrite your change. Follow that application's procedure for changing data while it runs.

Database changes are recorded in the organization's audit log. If the panel reports that the change was saved but the audit log could not be updated, use Retry audit log.

Run raw SQL

Expert query runs a raw SQL statement against the selected source. It needs its own privileged grant, and some sources support browsing only.

Raw SQL bypasses the row editor's limits

A statement runs with the full privileges of the source's database account. Test a statement with a SELECT and a LIMIT first. Enderdash cannot undo an UPDATE, DELETE, or DROP.

If the panel or a source is unavailable

SymptomCheck
Databases is missingThe agent capability, the plan feature, and your server access
A source is unhealthyThe host, port, credentials, and network path from the agent's host
A SQLite file is not listedAdd it with its file path. Automatic discovery covers the server directory only
Your access does not include a tableAsk an owner or admin to review the source and table matchers in your grant
Write actions or expert queries are blockedYour grant covers reading only. Ask for the specific write or expert-query action

Next: plan and verify backups or scoped access grants.

Was this page helpful?

Send a quick note if anything is missing or unclear.

Last updated on