Azure Resource Manager Postgresql Dotnet

What it does

This skill allows AI agents to interact with Azure PostgreSQL databases using .NET code. It enables the agent to execute SQL queries, manage database objects (like tables and indexes), and perform other administrative tasks programmatically through the Azure Resource Manager. This facilitates automated database management and integration within broader workflows.

When to use it

• Automated Database Backups: Schedule and automate PostgreSQL backups directly from an AI agent.
• Schema Migrations: Apply schema changes (e.g., adding a new column) to your PostgreSQL database using .NET scripts managed by the agent.
• Data Seeding/Loading: Populate a newly created PostgreSQL database with initial data based on predefined scripts.
• Performance Monitoring & Tuning: Execute SQL queries to monitor database performance and apply tuning adjustments as needed.

Key capabilities

• Azure Resource Manager interaction
• PostgreSQL database management
• .NET code execution for database tasks
• SQL query execution
• Database object manipulation (tables, indexes)

Example prompts

• "Run the 'backup_database.sql' script against my 'my-postgres-db' Azure PostgreSQL server."
• "Execute this SQL query: SELECT * FROM users WHERE last_login < DATEADD(day, -30, GETDATE()); on the database named 'production'."
• “Create a new table called ‘orders’ with columns for order ID, customer ID, and order date in my PostgreSQL database.”

Tips & gotchas

• Requires appropriate Azure credentials and permissions to access the PostgreSQL server.
• The agent needs access to .NET runtime environment to execute code.