postgresql
FreeProjete um schema específico para PostgreSQL. Abrange práticas recomendadas, tipos de dados, indexação, constraints, padrões de desempenho e recursos avançados
The English summary is being prepared. Showing the original description.
504 skills · sorted by relevance
Projete um schema específico para PostgreSQL. Abrange práticas recomendadas, tipos de dados, indexação, constraints, padrões de desempenho e recursos avançados
The English summary is being prepared. Showing the original description.
Workflow de otimização de banco de dados PostgreSQL para sintonia de consultas, estratégias de indexação, análise de desempenho e gerenciamento de banco de dados em produção.
The English summary is being prepared. Showing the original description.
Identifies Oracle-to-PostgreSQL migration risks by cross-referencing code against known behavioral differences (empty strings, refcursors, type coercion, sorting, timestamps, concurrent transactions, etc.). Use when planning migration of a procedure, trigger, query, or refcursor client, and again to validate the finished port.
The English summary is being prepared. Showing the original description.
Use when PostgreSQL logical replication slots retain WAL, become orphaned or invalid after switchover, or must be proven synchronized and usable before failover.
The English summary is being prepared. Showing the original description.
Creates integration test cases for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. Generates DB-agnostic xUnit tests with deterministic seed data that validate behavior consistency across both database systems. Use after the test project is scaffolded, to cover a project's data access code before porting it.
The English summary is being prepared. Showing the original description.
Render CLIを使用したクラウドサービス管理の専門スキル。デプロイ、ログ監視、SSH接続、PostgreSQL接続、サービス管理などRenderプラットフォームのCLI操作を効率的に支援。定期的に公式ドキュメントをチェックして最新情報を取得。Use when managing Render services via CLI, deploying applications, viewing logs, connecting to databases, or automating cloud infrastructure tasks.
The English summary is being prepared. Showing the original description.
PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.
The English summary is being prepared. Showing the original description.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
The English summary is being prepared. Showing the original description.
Reviews Laravel migrations for destructive operations, change() dropping modifiers, locking index creation on large tables (PostgreSQL), and asymmetric down().
The English summary is being prepared. Showing the original description.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
The English summary is being prepared. Showing the original description.
Use when doing ANY task involving Supabase. Triggers: Supabase products (Database, Auth, Edge Functions, Realtime, Storage, Vectors, Cron, Queues); client libraries and SSR integrations (supabase-js, @supabase/ssr) in Next.js, React, SvelteKit, Astro, Remix; auth issues (login, logout, sessions, JWT, cookies, getSession, getUser, getClaims, RLS); Supabase CLI or MCP server; schema changes, migrations, declarative schemas, security audits, Postgres extensions (pg_graphql, pg_cron, pg_vector); debugging and troubleshooting errors or unexpected behavior on Supabase projects (HTTP errors, Postgres errors, RLS surprises, permission denied, schema cache issues, timeouts, Edge Function crashes, Realtime drops, Storage failures) and reading or querying logs (Logs Explorer, ClickHouse).
The English summary is being prepared. Showing the original description.
Expert en bases de données (PostgreSQL, MySQL, MongoDB, Redis, query optimization, replication)
The English summary is being prepared. Showing the original description.
Database Architect IA — Expert en conception de bases de données (PostgreSQL, MongoDB, Redis, schema design, migrations). Optimise le stockage et l'accès aux données.
The English summary is being prepared. Showing the original description.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
The English summary is being prepared. Showing the original description.
Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration
The English summary is being prepared. Showing the original description.
Postgres performance, schema, and operations best practices.
The English summary is being prepared. Showing the original description.
Rust 製ローカルファースト vector 特化クエリ DB fandhe-db (PostgreSQL wire protocol v3 互換) の fandhe-db-engine / fandhe-db-wire-server リファレンス。 USING PLAN / USING OPERATION_ID 構文、DDL / JOIN / CTE / window 関数、 拡張クエリ・COPY・トランザクション、TLS 1.3 / SCRAM-SHA-256、 NoSQL HTTP 表層、precision・recall モード、HNSW / BM25 / RRF hybrid / rerank、 redb 永続化、tenant・RLS、SIMD / wgpu、wire_code エラー契約。
The English summary is being prepared. Showing the original description.
Guide the user through connecting a new data warehouse source — Postgres, MySQL, Stripe, Hubspot, MongoDB, Salesforce, BigQuery, Snowflake, and so on. Use when the user wants to "connect Stripe", "import data from Postgres", "add a new data source", "sync my warehouse tables", or wants to pick sync methods for each table. Walks through source-type discovery, credential validation, table discovery, per-table sync_type selection, and the final create call. Also covers picking a good prefix and what to do right after creation.
The English summary is being prepared. Showing the original description.
Provides expert knowledge of JPA entity design, relationship mapping, Flyway migrations, and PostgreSQL-specific optimizations.
The English summary is being prepared. Showing the original description.
Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.). Use when setting up a new project, changing databases, or troubleshooting connection issues. Triggers on "configure postgres", "connect to mysql", "setup mongodb", "sqlite setup".
The English summary is being prepared. Showing the original description.
PostgreSQL、MySQL、および一般的なORM(Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate)にわたるスキーマ変更、データマイグレーション、ロールバック、ゼロダウンタイムデプロイメントのためのデータベースマイグレーションベストプラクティス。
The English summary is being prepared. Showing the original description.
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
The English summary is being prepared. Showing the original description.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
The English summary is being prepared. Showing the original description.
Use the Fly.io flyctl CLI for deploying and operating apps on Fly.io: deploys (local or remote builder), viewing status/logs, SSH/console, secrets/config, scaling, machines, volumes, and Fly Postgres (create/attach/manage databases). Use when asked to deploy to Fly.io, debug fly deploy/build/runtime failures, set up GitHub Actions deploys/previews, or safely manage Fly apps and Postgres.
The English summary is being prepared. Showing the original description.