Browsing Data & Running Queries

ServerPlane provides a built-in data browser and query runner so you can inspect your database without needing a separate client.

Browse Tab

The Browse tab lets you view tables (or collections for MongoDB) and their data.

Listing Tables

1. Open a database's detail page and go to the Browse tab.
2. Click Refresh to load the list of tables (or collections for MongoDB).
3. Tables are displayed in a list. Click any table name to view its data.

Viewing Table Data

After clicking a table:

• Data is displayed in a paginated table view, 50 rows per page.
• Column headers are shown at the top.
• NULL values are displayed in gray italic text.
• Long values are truncated to 100 characters. Hover over a cell to see the full value in a tooltip.
• Use the Previous and Next buttons at the top to navigate between pages.
• The footer shows which rows are currently displayed (e.g., "Showing rows 1-50") and the per-page count.
• Click the back arrow to return to the table list.

MongoDB Collections

For MongoDB databases, the Browse tab shows collections instead of tables. Document fields are automatically extracted as columns. Complex nested values (objects, arrays) are displayed as JSON strings.

Query Tab

The Query tab lets you run custom queries against your database.

1. Open a database's detail page and go to the Query tab.
2. Enter your query in the text area:
   • MariaDB / PostgreSQL — Read-only queries only: SELECT, SHOW, DESCRIBE, EXPLAIN.
   • MongoDB — MongoDB shell commands, e.g., db.collection.find().limit(10).
3. Click Run Query.
4. Results are displayed in a terminal-style panel with green text on a dark background.

Examples

MariaDB / PostgreSQL:

SELECT * FROM users LIMIT 10;

MongoDB:

db.orders.find({status: "active"}).limit(10)

Notes

• The Query tab is restricted to read-only operations for SQL databases to prevent accidental data modification.
• For write operations, use the database credentials with an external client (e.g., TablePlus, DBeaver, or the psql / mysql CLI).
• Large result sets may be truncated in the output display. Use LIMIT to control output size.