'postgres' 검색 결과

운영 데이터베이스의 구조 변경과 기존 데이터 이전을 계획합니다. 열과 인덱스 추가, 단계적 전환, 복구 절차를 정리하고 중단 시간과 잠금을 고려한 변경을 돕습니다.

• 운영 테이블에 열이나 인덱스 추가
• 대량 데이터의 분할 갱신
• 앱을 중단하지 않고 열 교체

Guide Prisma 8 development by selecting task-specific references for data definitions, queries, migrations that change database structure, runtime setup, debugging, and upgrades. Check package versions and generated contract files before proceeding with implementation.

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

• Set up Prisma 8 or connect it to an existing database
• Edit data definitions and plan database migrations
• Write queries and configure database connections

Design storage for event sourcing, an approach that records changes as events. Compare database options and plan event ordering, duplicate handling, concurrent writes, and scaling to build a consistent event persistence layer.

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

• Compare event storage technologies
• Design event schemas and streams
• Handle concurrent and duplicate writes

Design a database layer from business requirements, access patterns, and expected growth. Compare database technologies, define tables and relationships, and plan indexes, caching, scaling, migrations, backups, and recovery with clear reasons and trade-offs.

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

• Choosing a database for a new service
• Designing tables, relationships, and indexes
• Planning database migrations and rollback procedures

Run cognee in Docker, starting with a prebuilt image for local document ingestion and questions. It also covers Docker Compose profiles for adding the UI, MCP server, Postgres, and Neo4j, plus persistent data storage.

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

• Try cognee locally using a prebuilt Docker image
• Test document ingestion and questions through the API
• Start the UI, MCP server, and databases with Docker Compose

Turn a plain-language data request into SQL tailored to your database. Build queries that combine tables, filter records, and calculate summaries, with explanations of each step, performance considerations, and suggestions for adjusting dates or other conditions.

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

• Create SQL for order counts by status
• Analyze retention by signup month
• Query large tables with date-based partitions

Turn everyday questions into SQL queries, the commands used to retrieve and summarize database records. Uses your database structure and platform to produce queries with explanations, performance notes, and optional validation scripts.

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

• Extract users who meet specific activity conditions
• Build revenue reports by region and customer tier
• Create queries from database diagrams

Verify Kortix changes with focused tests and real inputs and outputs. This skill guides test placement, API and CLI workflows, browser checks, database verification, and reporting of results, including skipped cases.

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

• Verify a bug fix with focused tests
• Check API and CLI behavior through real inputs and outputs
• Test database query conditions

Write, debug, and optimize SQL queries for data analysis and database design. The skill covers aggregations, rankings, missing values, and indexes, using execution plans to understand performance and adapting syntax to the database in use.

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

• Writing queries for totals and rankings
• Investigating slow queries with execution plans
• Reviewing table structures and constraints

Create and validate mirrord.json settings for isolated database copies used in development and testing. Configure connection sources, copying scope, migrations, and authentication so experiments can run without affecting shared databases.

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

• Preparing isolated databases for development and testing
• Choosing which schemas and data to copy
• Configuring connection sources and IAM authentication

Understand how OPC coordinates multiple Claude Code processes through event hooks, skills, scripts, files, and a database. It explains child-agent startup, process tracking, output storage, and completion reporting, helping readers follow the system's architecture.

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

• Understanding the components of OPC
• Tracing how child agents start and finish
• Locating hook settings and agent output files

Advises on Amazon RDS open-source engines (MySQL, MariaDB, PostgreSQL) for instance creation, upgrade planning, commitment pricing, proxy evaluation, and Blue/Green deployments. Handles any RDS MySQL, MariaDB, or PostgreSQL question, including create a production-ready RDS MySQL instance, provision an RDS PostgreSQL database, run the RDS upgrade advisor for my RDS MySQL instance, what are my upgrade options, upgrade RDS MariaDB from 10.6 to the latest version, should I buy reserved instances or a savings plan for db.r7g.2xlarge RDS MySQL, change a VARCHAR to INT column on RDS MySQL 8.0 with Blue/Green, and does RDS Proxy help when PgBouncer already runs in transaction mode. Covers instance creation with production best practices, describe-db-instances and describe-db-engine-versions upgrade-target workflow, live prechecks via SSM or direct connection, RI versus DSP commitment pricing, RDS Proxy versus PgBouncer, and Blue/Green lifecycle with binlog replay compatibility.

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

Amazon Aurora MySQL — creates, modifies, and advises on Aurora MySQL clusters specifically (MySQL-compatible engine, Aurora serverless, parallel query). Trigger for Aurora MySQL cluster operations, ACU sizing, I/O-Optimized storage, commitment pricing, or MySQL upgrade planning. Aurora MySQL uses full (VPC-based) configuration — express configuration is PostgreSQL-only. For Aurora PostgreSQL, use amazon-aurora-postgresql instead. Contains safety guardrails and response templates that override defaults.

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

Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation. **Trigger when user asks to:** - Migrate or convert PostgreSQL tables to hypertables - Execute hypertable migration with minimal downtime - Plan blue-green migration for large tables - Validate hypertable migration success - Configure compression after migration **Prerequisites:** Tables already identified as candidates (use find-hypertable-candidates first if needed) **Keywords:** migrate to hypertable, convert table, Timescale, TimescaleDB, blue-green migration, in-place conversion, create_hypertable, migration validation, compression setup Step-by-step migration planning including: partition column selection, chunk interval calculation, PK/constraint handling, migration execution (in-place vs blue-green), and performance validation queries.

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

Plan and implement OpenMeld PostgreSQL business persistence, schemas and migrations, transactions, Hyperdrive access, and data cutover. Use for the shared relational database transition or PostgreSQL work; not for unrelated D1 performance fixes or OpenConnector's upstream database.

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

Inspect Neon serverless Postgres: projects, branches, databases. Branch create and delete need exact-match confirmation; connection passwords are masked. Trigger phrases: neon, serverless postgres, database branch, postgres project.

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

Administer PostgreSQL databases. Configure replication, backups, and performance tuning. Use when managing PostgreSQL deployments.

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

Use when building, debugging, or evaluating CloudBase PostgreSQL / CloudBase PG / PG mode apps, including Postgres schema setup, queryPgDatabase/managePgDatabase, JS SDK v3 app.rdb() CRUD/RPC, PG HTTP API fallback, RLS-style permissions, username-password auth, and Web CMS/admin CRUD flows backed by CloudBase PG.

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

Expert knowledge for Azure Database for PostgreSQL development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when using Flexible Server, pgvector/Apache AGE, Private Link/TLS, replicas/PITR, or Azure AI/ML integrations, and other Azure Database for PostgreSQL related development tasks. Not for Azure SQL Database (use azure-sql-database), Azure SQL Managed Instance (use azure-sql-managed-instance), SQL Server on Azure Virtual Machines (use azure-sql-virtual-machines), Azure Database for MySQL (use azure-database-mysql).

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

在PostgreSQL中格式化数字显示，去除小数点后的尾随零，并在小数点后无数字时去除小数点。

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

Apply PostgreSQL standards for migrations, indexing, transactions, and ORM boundaries. Use when editing entities, Prisma schema, migrations, RLS, or query-performance work for PostgreSQL.

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

Execute read-only SQL queries against multiple PostgreSQL databases. Use when: (1) querying PostgreSQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

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

PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with PostgreSQL databases, writing SQL, or managing database systems.

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

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

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