'postgres' 검색 결과

Write complex SQL, improve slow queries, and design database schemas for transaction processing and analytics. Uses schema details and query execution plans to guide indexing, validate results, and assess performance with realistic data volumes.

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

• Investigate and improve slow analytical queries
• Design a database schema for a SaaS application
• Write customer retention and cohort analysis queries

Investigate database slowdowns and plan measurable improvements to queries, indexes, caching, and scaling. The skill covers SQL and NoSQL systems, with guidance on monitoring, load testing, migrations, and balancing performance against cost.

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

• Analyze slow SQL queries and execution plans
• Resolve repeated database calls in APIs
• Plan indexes and caching for high traffic

Use Phoenix to record execution traces, detailed records of an AI application's operations, and investigate problems. Evaluate answers on datasets, compare prompts and models, and set up monitoring through a self-hosted server.

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

• Investigate AI application problems using execution traces
• Evaluate answer quality across a test dataset
• Compare prompts and models through experiments

Turn plain language requirements into SQL, investigate slow queries, document database structures, and prepare migration templates with rollback plans. Support everyday database development and ORM use, where libraries connect application code to database tables.

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

• Writing SQL for reports and data retrieval
• Investigating slow queries and repeated database calls
• Preparing schema changes and rollback plans

Monitor a data warehouse for stale tables, unusual row counts, column changes, and failed loads. Receive alerts with evidence and likely causes, plus GitHub issues for human review, while warehouse data remains unchanged.

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

• Check warehouse health every hour
• Investigate delayed table updates
• Detect unusual row counts or column changes

Combine product usage, support issues, payment status, and renewal dates to rank accounts by churn risk, meaning the risk of cancellation. Produce a Slack list with specific evidence and a suggested next action for each account.

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

• Reviewing accounts at risk of cancellation each day
• Prioritizing outreach before contract renewals
• Understanding why an account received a high risk rating

Find the Wren CLI workflow for answering data questions, connecting databases or SaaS sources, generating model definitions, adding business metrics, or building a shareable analytics app. Guides are retrieved from the installed CLI version.

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

• Set up Wren and connect a database
• Load HubSpot or Stripe data through dlt
• Generate model definitions and add business metrics

Use Phoenix to record execution traces, detailed records of an AI application's operations, and investigate problems. Evaluate answers on datasets, compare prompts and models, and set up monitoring through a self-hosted server.

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

• Investigate AI application problems using execution traces
• Evaluate answer quality across a test dataset
• Compare prompts and models through experiments

Investigate slow SQL, write complex joins and summaries, and design database structures. Uses execution plans, which show how queries run, to guide index choices and query rewrites, with before-and-after performance measurements.

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

• Investigate a slow SQL query
• Write complex joins and grouped calculations
• Design tables, keys, and constraints

Audit database migration changes before a Bifrost release for lock contention, deadlocks, and delayed application startup. Receive pass, warning, or failure results, a release recommendation, and concrete remediation steps without modifying files.

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

• Review migration safety before a release
• Check index creation risks on large log tables
• Find migration work that delays application startup

Assess web applications and APIs for SQL injection, where input changes database queries. The skill covers finding vulnerable inputs, testing different database systems, automating checks, and documenting findings with remediation suggestions.

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

• Assessing web application inputs for SQL injection
• Reviewing GraphQL and WebSocket injection risks
• Combining SQLmap automation with manual verification

Deploy n8n on a Linux server using Docker Compose and Caddy for automatic HTTPS. Choose a single instance or queue workers, configure secrets and Python task runners, and follow procedures for updates, backups, and recovery.

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

• Deploy n8n on a personal VPS with HTTPS
• Set up queue workers for parallel workflow execution
• Update, back up, or restore an n8n instance

Guides deployment of Open Harness on Vercel, from collecting credentials and setting environment variables to checking the first session. Separates a basic setup from a fuller setup with GitHub repository access.

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

• Deploying a personal copy of Open Harness
• Identifying credentials needed for a basic deployment
• Adding GitHub repository access

Design ClickHouse tables, write analytical queries, and plan data loading using practical SQL and code patterns. Use it to review slow queries, build recurring summaries, and analyze user activity across large datasets.

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

• Designing tables for large analytical datasets
• Investigating slow queries
• Building real-time summaries

Administer Observal users, settings, submission reviews, identity configuration, and security investigations. Also manage local server upgrades, rollback, and database schema migrations, checking the resulting state and protecting sensitive values throughout privileged operations.

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

• Managing users, permissions, and submission reviews
• Configuring SAML sign-in and SCIM user provisioning
• Investigating security events and audit logs

Audit Claude Code skills, agents, hooks, and a database-backed memory system. It reports configuration problems and broken references by severity, and offers an optional fix mode for permissions, hook builds, and missing cache directories.

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

• Auditing a Claude Code environment
• Finding missing configuration and broken references
• Checking the memory database connection

Understand how Continuous Claude stores session memories, runs automatic actions at key events, and passes work between sessions. The skill explains the setup, relevant files, recall commands, and available database options.

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

• Understanding what persists between sessions
• Checking automatic actions at session events
• Finding commands for handing off work

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

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

PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling

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

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

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

用于查询优化、模式设计、索引和安全性的PostgreSQL数据库模式。基于Supabase最佳实践。

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

PostgreSQL 数据库模式，涵盖查询优化、架构设计、索引和安全。基于 Supabase 最佳实践。

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

PostgreSQL 数据库模式，用于查询优化、架构设计、索引和安全性。基于 Supabase 最佳实践。

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

Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. **Trigger when user asks to:** - Analyze database tables for hypertable conversion potential - Identify time-series or event tables in an existing schema - Evaluate if a table would benefit from Timescale/TimescaleDB - Audit PostgreSQL tables for migration to Timescale/TimescaleDB/TigerData - Score or rank tables for hypertable candidacy **Keywords:** hypertable candidate, table analysis, migration assessment, Timescale, TimescaleDB, time-series detection, insert-heavy tables, event logs, audit tables Provides SQL queries to analyze table statistics, index patterns, and query patterns. Includes scoring criteria (8+ points = good candidate) and pattern recognition for IoT, events, transactions, and sequential data.

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