'postgres' 검색 결과

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".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Flox로 개발 도구와 데이터베이스의 구성 및 버전을 설정 파일에 정의합니다. macOS와 Linux에서 재현할 수 있는 개발 환경을 만들고 팀과 공유합니다.

• 팀의 개발 환경 통일
• 언어 도구와 시스템 의존성 관리
• PostgreSQL과 Redis 로컬 실행

Stripe Projects로 프로젝트에 데이터베이스와 SMS 등 외부 서비스를 준비합니다. 인증 정보를 `.env`에 동기화하고 키 갱신, 요금제 변경과 서비스 제거를 관리합니다.

• 프로젝트용 Neon Postgres 준비
• 앱에 SMS 서비스 추가
• 인증 정보 동기화와 키 갱신

Investigate slow PostgreSQL queries in Paperclip, reproduce their cost locally, and implement measured fixes. Compare performance and returned results, add regression coverage, and carry pull requests through review and automated checks.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigate slow requests with a suspected database cause
• Reduce the cost of frequently repeated queries
• Compare query speed and results before and after a fix

Design PostgreSQL tables by choosing data types, validation rules, and indexes that match actual queries. The skill also guides JSONB usage, partitioning large tables, and planning schema changes with attention to read and write workloads.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Designing tables for users and orders
• Reviewing indexes against actual queries
• Choosing between relational columns and JSONB

Diagnose and repair GBrain’s Postgres access with a fixed recovery command. Apply routine fixes, request approval for configuration rewrites, and verify connectivity afterward. Credential problems and other manual cases are returned with instructions for the operator.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Diagnose GBrain database connection failures
• Apply routine fixes such as reconnecting or pending migrations
• Review and approve connection configuration rewrites

Create and administer AlloyDB for PostgreSQL databases, including clusters, instances, backups, secure connections, and access permissions. It also covers command-line operations, infrastructure configuration, and MCP tools that let agents automate database tasks.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Create an AlloyDB cluster and primary instance
• Manage backups and plan recovery
• Configure secure connections and access permissions

Create weekly reports from Postgres metrics, comparing current figures with recent weeks. Add plain-language explanations for notable changes, flag missing data, and post one report to Slack while keeping database access read-only.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Preparing a weekly metrics report for Slack
• Reviewing weekly changes and recent trends
• Explaining notable changes and flagging data gaps

Use this skill for general PostgreSQL table design. **Trigger when user asks to:** - Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones. - Choose data types, constraints, or indexes for PostgreSQL - Create user tables, order tables, reference tables, or JSONB schemas - Understand PostgreSQL best practices for normalization, constraints, or indexing - Design update-heavy, upsert-heavy, or OLTP-style tables **Keywords:** PostgreSQL schema, table design, data types, PRIMARY KEY, FOREIGN KEY, indexes, B-tree, GIN, JSONB, constraints, normalization, identity columns, partitioning, row-level security Comprehensive reference covering data types, indexing strategies, constraints, JSONB patterns, partitioning, and PostgreSQL-specific best practices.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and PostgreSQL extensions ecosystem. Use when writing or tuning PostgreSQL-specific SQL or choosing PostgreSQL features for a design.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Create a new PostgreSQL CDC capture from scratch using flowctl. Covers all Postgres variants (vanilla, Aurora, RDS, Cloud SQL, Supabase, Neon). Use when user says "capture Postgres", "stream from Postgres", "Postgres CDC", "set up replication slot", or "connect Postgres to Estuary".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Quality gates determinísticos para PostgreSQL. Use quando o usuário pedir "quality gate PostgreSQL", "quality gate Postgres", migrations ou schema drift PostgreSQL, constraints ou índices PostgreSQL, EXPLAIN, plano de consulta ou baseline para PostgreSQL.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Design PostgreSQL tables around actual queries and data volumes. Choose data types, validation rules, and indexes, then plan large table partitioning, access rules for individual rows, and schema changes with migration and rollback considerations.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Designing tables for users, orders, and related data
• Reviewing data types, constraints, and indexes
• Planning large tables and frequent update workloads

Set up and manage AlloyDB for PostgreSQL clusters, instances, and backups. Includes guidance for MCP integration, a way for agents to operate databases, plus references for application connections, Terraform, authentication, and AI search capabilities.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Create an AlloyDB cluster and primary instance
• Manage AlloyDB backups
• Automate database operations through MCP

Write and improve SQL for major data warehouses, accounting for differences in their syntax. Use it to build analytical queries, translate existing SQL, investigate errors, and review slow queries for performance improvements.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Translate SQL from PostgreSQL to BigQuery
• Review slow queries for performance improvements
• Calculate retention rates and funnel conversion

Develop time-series and event-data solutions with TimescaleDB, an extension for PostgreSQL. The skill provides organized references for installation, time-based tables, ongoing aggregate calculations, compression, and performance troubleshooting.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Learn how to install and use TimescaleDB
• Design tables for time-series and event data
• Implement time-bucket and continuous aggregates

Prepare quarterly business reviews using account records from HubSpot and usage trends from Postgres. Create a draft slide deck and supporting document for each due account, with traceable figures, support issues, and evidence-backed expansion opportunities.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Prepare quarterly reviews for accounts due soon
• Review declining usage and important support issues
• Gather supporting data for customer discussions

Draft monthly investor updates from Stripe, Postgres, and the previous report. Compare revenue, recurring subscription revenue, account activity, cash burn, and runway against last month and plan, then create a new document for the founder to review.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Prepare a monthly investor update
• Compare business metrics with last month and plan
• Draft explanations for revenue and cash changes

Check new customer onboarding progress using HubSpot and Postgres, identify stalled or overdue milestones, and prepare emails tailored to the missed step. Notify the customer success manager while leaving customer communication to human review.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Daily checks of new customer onboarding progress
• Drafting helpful emails for stalled setup steps
• Reminding customer success managers about overdue accounts

Investigate slow PostgreSQL and MySQL queries using execution plans, which show how the database runs a query. Develop index, SQL, and configuration changes, then compare measurements before and after each change to validate the results.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigating slow SQL queries
• Reviewing database index design
• Tuning memory and database configuration

Amazon Aurora PostgreSQL — creates, modifies, and advises on Aurora PostgreSQL clusters specifically (PostgreSQL-compatible engine, Aurora serverless, express configuration, pgvector, Babelfish). Trigger for Aurora PostgreSQL cluster operations, express-configuration quick-start, ACU sizing, I/O-Optimized storage, commitment pricing, or PostgreSQL upgrade planning. For Aurora MySQL, use amazon-aurora-mysql instead. Contains safety guardrails, express-first routing, and response templates that override defaults.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. **Trigger when user asks to:** - Explore an existing PostgreSQL database to understand its objects and relationships - Design or modify PostgreSQL tables, schemas, or data models - Choose data types, constraints, indexes, or partitioning strategies - Work with pgvector embeddings, semantic search, or RAG - Set up full-text search, hybrid search, or BM25 ranking - Use PostGIS for spatial/geographic data - Set up TimescaleDB hypertables for time-series data - Migrate tables to hypertables or evaluate migration candidates - Plan or execute safe schema migrations with zero downtime **Keywords:** PostgreSQL, Postgres, SQL, schema, table design, indexes, constraints, pgvector, PostGIS, TimescaleDB, hypertable, semantic search, hybrid search, BM25, time-series, migration

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

pg-boss expert for PostgreSQL-backed job queues with exactly-once delivery, perfect for applications already using Postgres (Supabase, Neon, etc.). Use when "pg-boss, postgres queue, postgresql job, supabase background job, neon job queue, postgres scheduling, database job queue, pg-boss, postgresql, job-queue, background-jobs, supabase, neon, exactly-once, scheduling" mentioned.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integrationUse when "neon database, serverless postgres, database branching, neon postgres, postgres serverless, connection pooling, preview environments, database per preview, neon, postgres, serverless, database, branching, prisma, drizzle, connection-pooling" mentioned.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.