databases

Database Console

Run SQL queries and view your database schema from the dashboard.

The Runix dashboard includes a built-in SQL editor for your PostgreSQL databases. Run queries, explore your schema, and inspect data without installing any client tools.

Opening the Console#

Go to the dashboard

Open your Runix dashboard and navigate to the service that has a PostgreSQL database.

Click the Database tab

In the service detail page, click the "Database" or "Console" tab to open the SQL editor.

Run a query

Type your SQL in the editor and click "Run" or press Ctrl+Enter (Cmd+Enter on Mac).

Example Queries#

List all tables

sql

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'public'
ORDER BY table_name;

View table schema

sql

SELECT column_name, data_type, is_nullable, column_default
FROM information_schema.columns
WHERE table_name = 'users'
ORDER BY ordinal_position;

Count rows in a table

sql

SELECT COUNT(*) FROM users;

View recent records

sql

SELECT *
FROM users
ORDER BY created_at DESC
LIMIT 10;

Features#

Syntax highlighting for SQL
Results displayed in a sortable, scrollable table
View table schemas and column types
Execute SELECT, INSERT, UPDATE, DELETE, and DDL statements
Query history for quick re-runs

The database console has full write access. Be careful with UPDATE and DELETE statements. There is no undo for data modifications.

Use the console for quick debugging and data inspection. For migrations and schema changes, use a proper migration tool (Prisma, SQLx, Alembic) in your application.

Kafka

Overview