postgres

Automate PostgreSQL database administration by applying workflows for schema changes, backups, and diagnostics. This requires a connection string and access to psql tools to execute reliable data management operations across development and production environments.

Run PostgreSQL diagnostics by inspecting table statistics and analyzing workloads to identify slow operations. This allows you to monitor query performance and pinpoint bottlenecks requiring performance tuning or parameter adjustments in your database environment.

Yes, you need psql tools such as psql, pg_dump, and pg_restore installed alongside a valid DATABASE_URL connection string. These tools are required to execute queries, manage schema migrations, and perform backup and restore workflows remotely.

Yes, you can create consistent PostgreSQL backups that are table-specific or schema-only. Using pg_dump, you can generate targeted dumps and subsequently restore them using pg_restore to manage controlled schema migrations or isolated data recovery.

Safely apply schema changes to a production PostgreSQL database by running controlled migration workflows that track schema evolutions. This ensures reliable data management and prevents deployment errors during schema modifications in live environments.

Performance tuning for slow PostgreSQL workloads involves analyzing database operations, tuning configuration parameters, and monitoring query performance. This diagnostic process identifies slow operations and applies optimizations to improve overall workload execution speed.