Upgrade PostgreSQL database versions safely for Heroku apps. Plan migration paths, verify compatibility, and execute controlled upgrades with confirmation protection to ensure a secure transition.
Creates a registered application's PostgreSQL database and role, generates its password on the host, and writes PostgreSQL and Valkey settings to shared/.env from a matching plan.
Establish database connections for PostgreSQL, MySQL, or SQLite to enable querying, schema management, and migration operations within the Berth MCP server.
Provides real-time system metrics and information through a Model Context Protocol interface, enabling access to CPU usage, memory statistics, disk information, network status, and running processes.
Plan a registered application's PostgreSQL database, database role, Valkey namespace, and protected remote environment file without applying any changes.
Run SQL queries to analyze, modify, or troubleshoot Heroku PostgreSQL databases. Execute commands or file-based queries with credential management for direct database access.
Analyze Heroku PostgreSQL database configurations, monitor performance metrics, and assess health and resource usage. Obtain detailed insights into database operations for informed decision-making.
Run read-only SQL statements on your PostgreSQL database to fetch data without risking modifications, as writes are automatically rejected and transactions rolled back.
Connect to any PostgreSQL database to check connection status or discover available databases. Supports SSL, AWS Secrets Manager, and automatic instance discovery.
Update the active PostgreSQL database or schema without reconnecting. Omit a parameter to keep it unchanged, enabling quick context switches for queries.