Automate PostgreSQL database operations with EF Core migrations, indexing, and transactions.
npx skills add https://github.com/jnPiyush/AI-Squad --skill database-jnpiyush
Please help me install this Agent Skill. Skill: database Source: https://github.com/jnPiyush/AI-Squad/tree/main/ai_squad/skills/database Command: npx skills add https://github.com/jnPiyush/AI-Squad --skill database-jnpiyush
This Skill provides a structured approach to managing PostgreSQL databases in .NET projects using Entity Framework Core, migrations, and robust transaction handling. It helps teams maintain schema evolution, optimize queries, and ensure reliable connections in production workloads.
dotnet new console -n DemoApp cd DemoApp dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL dotnet ef migrations add InitialCreate dotnet ef database update dotnet ef migrations script --output migration.sql // Example project scaffold and commands to bootstrap the workflow.
High-intent search queries and answers about installing and using this skill.
PostgreSQL migrations with EF Core are automated using 'dotnet ef migrations add' to scaffold schema changes and 'dotnet ef database update' to apply them. You can also generate migration SQL scripts for controlled deployment.
Transactions in PostgreSQL with EF Core are handled using explicit transaction patterns for multi-step operations. This approach ensures rollback safety and robust data integrity if any step fails during complex data modifications.
Connection pooling for PostgreSQL is configured through the Npgsql provider settings in your EF Core setup. Proper configuration manages database connections efficiently, ensuring scalable apps and reliable connections under production workloads.
You need to add indexes for query optimization in PostgreSQL when schema evolution introduces slow queries. Applying index best practices and concrete indexing strategies optimizes query performance for production database workloads.
Yes, you can use the repository pattern with EF Core and PostgreSQL. This Skill provides repository pattern implementations and data access best practices to structure your data layer reliably.
Your EF Core PostgreSQL connection needs retry strategies to handle transient connection failures in production workloads. Configuring retry strategies during EF Core setup ensures robust and reliable database connections.
MudraMartinOptimize EF Core queries, migrations, and change tracking in .NET applications.
Rune-kitGenerate and validate database schema migrations for ORMs and raw SQL.
dhruvinrsoniImplement data access layers with Repository pattern, transaction management, and N+1 prevention.
seb1nAnalyze EXPLAIN plans and rewrite slow SQL queries for better performance.
