478 skills · sorted by relevance
Check whether gbrain uses PGLite or Postgres, set up a Postgres-backed installation, or migrate existing PGLite data with its history. The workflow presents a migration plan for approval, verifies transferred tables, and supports interrupted migration recovery.
Migrate the database access layer of a .NET/C# application from Oracle to PostgreSQL with Npgsql. Update packages, connection settings, parameter types, SQL, and stored procedure calls, then build the copied project and track completed migration tasks.
Provision a PostgreSQL database with Neon Instagres and save connection settings for application use and migrations. Includes setup examples for Drizzle and Prisma, initial data loading, and claiming a temporary database to keep using it.
Design and review PostgreSQL database schemas by choosing suitable column types, keys, constraints, and indexes. It also guides decisions about large-table partitioning, flexible JSONB data, and schema changes on a live database without downtime.
Review PostgreSQL queries and data designs using execution plans, which show how queries run, and targeted index recommendations. Get guidance on JSONB, arrays, full-text search, analytical queries, extensions, and routine database maintenance.
Convert Oracle stored procedures and functions, programs stored inside a database, into PostgreSQL equivalents. Preserve parameters and control flow while adapting Oracle syntax, resolving types, and mapping text sorting rules to the target environment.
Create and connect to managed MySQL, PostgreSQL, or SQL Server databases on Google Cloud. This skill guides instance setup, database creation, access permissions, and connection steps, with references for backups, security, and Terraform configuration.
Azure PostgreSQL Flexible Server SDK for .NET. Database management for PostgreSQL Flexible Server deployments. Use for creating servers, databases, firewall rules, configurations, backups, and high availability. Triggers: "PostgreSQL", "PostgreSqlFlexibleServer", "PostgreSQL Flexible Server", "Azure Database for PostgreSQL", "PostgreSQL database management", "PostgreSQL firewall", "PostgreSQL backup", "Postgres".
The English summary is being prepared. Showing the original description.
Improve PostgreSQL performance through a staged workflow covering slow query analysis, indexes that speed up data access, query rewrites, configuration tuning, routine maintenance, and monitoring for production databases.
Create and manage MySQL, PostgreSQL, and SQL Server databases on Google Cloud. Covers instance setup, users, backups, availability, and secure connections, with a PostgreSQL walkthrough and references for application connectors and Terraform configuration.
Get documentation-based help with PostgreSQL queries, database design, administration, and performance tuning. The supplied reference also explains connection settings and libpq, PostgreSQL’s C client library, for investigating connection failures and implementing connection handling.
Build and run Omnigent’s server and Postgres together with Docker Compose on a laptop or existing Docker host. Use the supplied configuration and troubleshooting guidance to rebuild images, investigate startup problems, or adapt deployment to another platform.
Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package. Use for PostgreSQL queries, connection pooling, transactions, and Microsoft Entra ID (passwordless) authentication. Triggers: "PostgreSQL", "postgres", "pg client", "node-postgres", "Azure PostgreSQL connection", "PostgreSQL TypeScript", "pg Pool", "passwordless postgres".
The English summary is being prepared. Showing the original description.
Guide PostgreSQL database design and troubleshooting with examples for faster queries, indexes that speed up searches, suitable data types, and row-level access rules. Also covers connection settings and SQL for investigating performance problems.
Review PostgreSQL code for database design, performance, and security issues. Get improvement suggestions covering JSONB, a binary JSON format, arrays, indexes, custom data types, functions, extensions, and rules that control access to individual rows.
Analyzes one .NET project to plan integration tests for an Oracle-to-PostgreSQL migration. Identifies database access methods, prioritizes migration risks, and documents test cases, seed data, and coverage, including empty strings, NULL values, and timezone behavior.
Turn defects found during Oracle-to-PostgreSQL migration into structured bug reports. Document expected and actual behavior, reproduction steps, severity, root causes, proposed changes, and validation on both databases so teams can act on the findings.
Guides Postgres query writing, schema design, and configuration reviews using Supabase's prioritized rules. Helps identify improvements in query performance, connection management, and row-level security, which controls access to individual rows.
Review every project in a .NET solution for Oracle dependencies, classify its migration status, and create a saved PostgreSQL migration plan with a project inventory and an order that prioritizes shared libraries.
Create integration tests for .NET database access before migrating from Oracle to PostgreSQL. The tests record expected Oracle behavior with controlled test data and portable checks, providing a baseline for later migration validation.
Design and build backend services with API scaffolding, database migrations, authentication reviews, and load testing. Generate route handlers from OpenAPI specifications, identify PostgreSQL optimization opportunities, and compare architecture choices against traffic, data sensitivity, and reliability requirements.
Improve PostgreSQL queries and database design by examining execution plans and choosing indexes for actual access patterns. Get guidance on large tables, JSONB data, connection pooling, and maintenance while accounting for write overhead and memory use.
Analyze and tune PostgreSQL databases using query execution plans, which show how queries run. This skill guides index design, JSONB searches, replication setup, maintenance, and monitoring, with checks to compare behavior before and after changes.
Create a PostgreSQL materialization to stream Estuary collections into PostgreSQL tables. Use when setting up PostgreSQL as a destination for captured data. Use when user says "send to Postgres", "materialize to PostgreSQL", "Postgres destination", or "load into Postgres".
The English summary is being prepared. Showing the original description.