Pscale Database

pscale database

Create, read, delete, and manage databases.

Common Commands

# List all databases
pscale database list --org <org>

# Create database
pscale database create <database> --org <org>

# Show database details
pscale database show <database>

# Delete database
pscale database delete <database>

# Open database shell
pscale shell <database> <branch>

Workflows

Database Creation

# Create new database
pscale database create my-new-db --org my-org

# Create main branch (automatic)
# Create development branch
pscale branch create my-new-db development

Database Shell Access

# Open shell to specific branch
pscale shell my-database main

# Execute SQL directly
pscale shell my-database main --execute "SHOW TABLES"

# Run SQL from file
pscale shell my-database main < schema.sql

Troubleshooting

Cannot create database

Error: "Organization limit reached"

Solution: Upgrade plan or delete unused databases

Shell connection fails

Error: "Authentication failed"

Solution:

# Re-authenticate
pscale auth logout && pscale auth login

# Verify branch exists
pscale branch list <database>

Related Skills

• pscale-branch - Manage database branches
• pscale-password - Create connection passwords for databases

References

See references/commands.md for complete command reference.