Skip to main content
This guide will walk you through setting up Poge and running your first PostgreSQL query.
Before you begin, make sure you have PostgreSQL database credentials (host, port, database name, username, and password).

​
First-Time Setup

1

Open Poge

Navigate to https://poge.dev in your browser. You’ll be greeted with the welcome screen.
Poge runs entirely in your browser. No installation required.
2

Create Your Security PIN

Set up a 6-digit PIN to encrypt your database credentials and protect your data.
// The PIN is used to encrypt all your data with AES-256-GCM
const newServer: ServerConnection = {
  id: crypto.randomUUID(),
  host: "localhost",
  port: 5432,
  database: "mydb",
  username: "postgres",
  password: "secret", // Encrypted with your PIN
  connected: true,
  createdAt: new Date()
}
Remember your PIN! There’s no way to recover your data if you forget it. Your data is encrypted locally and never transmitted.
3

Choose Your Theme

Select your preferred appearance: Light, Dark, or System. You can change this later in settings.
4

Add Your First Server

Once setup is complete, click “Databases” in the sidebar, then “Add Server”.Fill in your PostgreSQL connection details:
  • Name: A friendly name for this connection (e.g., “Local Dev”)
  • Host: Your database host (e.g., localhost or db.example.com)
  • Port: PostgreSQL port (default: 5432)
  • Database: Database name
  • Username: Database user
  • Password: Database password
  • SSL Mode: Choose disable, prefer, or require
Poge tests the connection before saving to ensure your credentials are correct.
5

Run Your First Query

Navigate to the Query tab and enter your SQL:
SELECT * FROM users LIMIT 10;
Click “Run Query” or press Ctrl+Enter (Windows/Linux) or Cmd+Enter (Mac) to execute.Your results will appear below with options to:
  • Export as CSV, JSON, or Excel
  • Copy to clipboard
  • View execution time and row count

​
What’s Next?

​
Explore Your Tables

Click on any table in the sidebar to:
  • View table data with pagination
  • Inspect column types and constraints
  • See foreign key relationships
  • Export table data

​
Use Query Templates

Access pre-built query templates for common operations:
  • SELECT statements
  • INSERT / UPDATE / DELETE operations
  • Table creation
  • Index management

​
Save Queries

Create reusable queries by clicking the Save button in the query editor. Access saved queries from the sidebar.

​
Multi-Tab Queries

Open multiple query tabs to work on different queries simultaneously. Lock tabs to prevent accidental changes.
All your queries are automatically saved to query history. Access it from the History button in the query editor.

​
Import Existing Data

If you have a Poge backup from another device:
1

On the Welcome Screen

Look for “Have a backup?” at the bottom of the first setup screen.
2

Enter Your Backup Password

Type the password you used when creating the backup.
3

Select Your Backup File

Click “Import” and select your .enc backup file.Your servers, queries, and settings will be automatically restored.

​
Need Help?

If you run into issues:
  1. Check your database credentials: Ensure your PostgreSQL server is running and accessible
  2. Verify SSL settings: Some servers require SSL, others don’t support it
  3. Check firewall rules: Make sure your database port is accessible
  4. Review connection string: Double-check host, port, and database name
For security issues, follow the reporting instructions in the Security Policy.