Database Detail

Overview

The database overview page displays real-time status, usage metrics, and connection information.

Status and metadata

• Database name: Instance identifier
• Health status: Healthy/Unhealthy indicator
• Engine: PostgreSQL version (e.g., PostgreSQL 17)
• Region: Deployment location

Usage metrics

Three metric tiles display current billing period consumption:

Configuration

Connection strings

Generate connection strings by selecting a role and database from the dropdowns.

Connection URL format

postgresql://[role]:[password]@[host]/[database]?sslmode=require

Components:

• role: Database role/user name
• password: Role password (masked by default)
• host: Neon endpoint hostname
• database: Logical database name
• sslmode=require: SSL is mandatory

Output formats

Toggle between formats using the content switcher:

psql (Connection URL):

postgresql://neondb_owner:****@ep-xxx.region.aws.neon.tech/neondb?sslmode=require

Parameters (Environment Variables):

PGHOST='ep-xxx.region.aws.neon.tech'
PGDATABASE='neondb'
PGUSER='neondb_owner'
PGPASSWORD='****'
PGSSLMODE='require'

Next.js (.env.local):

DATABASE_URL="postgresql://neondb_owner:****@ep-xxx.region.aws.neon.tech/neondb?sslmode=require"

.NET (appsettings.json):

{
  "ConnectionStrings": {
    "DefaultConnection": "Host=ep-xxx.region.aws.neon.tech; Database=neondb; Username=neondb_owner; Password=****; SSL Mode=Require;"
  }
}

Java (JDBC URL):

jdbc:postgresql://ep-xxx.region.aws.neon.tech/neondb?user=neondb_owner&password=****&sslmode=require

Password visibility

• Click the eye icon to reveal/hide the password
• Click the copy icon to copy the full connection string (with password)

Access & Databases

Manage PostgreSQL roles and logical databases within your instance.

Roles

Roles control database authentication and permissions.

Create role:

1. Click Create Role
2. Enter role name (2–63 chars, lowercase, alphanumeric + hyphens)
3. Must start with a letter

Delete role:

• Click overflow menu → Delete
• Protected roles (e.g., neondb_owner) cannot be deleted
• Roles owning databases must have those databases deleted first

Databases

Logical databases within the PostgreSQL instance.

Create database:

1. Click Create Database
2. Enter database name (2–63 chars, lowercase, alphanumeric + hyphens)
3. Select owner role from dropdown

Delete database:

1. Click overflow menu → Delete
2. Type the database name to confirm (destructive action)

Settings

Scale

Configure compute autoscaling and idle behavior.

Compute Units (CU)

Allowed values:

0.25, 0.5, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16,
18, 20, 22, 24, 26, 28, 30, 32, 34, 36, 38, 40, 42, 44, 46, 48, 50, 52, 54, 56

Step increments:

• 0.25 → 16: step of 1
• 18 → 56: step of 2

Configuration:

RAM allocation: Each CU provides 4 GB of RAM.

Constraint: Max CU cannot be less than Min CU.

Suspend timeout

Configure how long the database waits before suspending after inactivity:

Cold start latency: ~500ms on first connection after suspend.

Network

Network settings control database accessibility. Available on Enterprise plans.

Visibility

Disable public access to restrict connections to internal services only.

IP Whitelist

When enabled, only specified IP addresses can connect.

Supported formats:

• IPv4: 192.168.1.100
• IPv6: 2001:db8::1
• CIDR: 192.168.1.0/24, 10.0.0.0/8

Actions:

• Add IP/CIDR to whitelist
• Remove IP from whitelist

Danger zone

Delete database instance

Permanently removes the entire database instance including:

• All roles
• All logical databases
• All data

Deletion process:

1. Navigate to database settings
2. Click Delete Database Instance
3. Type the database name to confirm
4. Click Delete

This action is irreversible and cannot be undone.

Activity

The activity table shows recent events for the database:

Features:

• Search events by keyword
• Paginate through history (5, 10, 20 items per page)
• Sort by any column