'sql' 검색 결과

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.

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

• Generating API route handlers from OpenAPI
• Investigating slow PostgreSQL queries
• Reviewing authentication and input validation

Design an enterprise search system that answers questions using retrieved company content, an approach called RAG. Gather requirements and produce architecture diagrams, deployment guidance, and validation plans using GKE, AlloyDB, and open models.

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

• Designing conversational search for internal documents
• Planning RAG with a vector-enabled SQL database
• Hosting open models on GKE

Convert Snowflake dbt SQL models to BigQuery through a bulk migration workflow. Preserve Jinja template logic while adapting configuration, explicit type conversions, JSON access, and deduplication patterns, with translated files saved in their directory structure.

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

• Migrating Snowflake dbt models to BigQuery in bulk
• Preserving dbt references and incremental processing logic
• Adapting JSON, array, and STRUCT access during migration

Answer business data questions with Wren CLI by checking model definitions, reusing past queries, and executing SQL or predefined aggregations. The workflow also covers query verification, error diagnosis, and saving successful queries for future use.

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

• Analyze monthly revenue trends
• Rank customers by purchase value
• Compare metrics across plans or regions

Use Quicknode to connect applications to blockchains, retrieve wallet and asset data, and monitor activity. Covers event notifications, live data streams, historical backfills, and SQL queries, with guidance for choosing suitable services and access methods.

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

• Connecting an app to blockchain data
• Setting up transaction and event notifications
• Recovering missing historical stream data

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.

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

SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server

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

Manages a Fabric SQL database item, the OLTP SQL Server engine, including running T-SQL through sqlcmd, temporal and vector similarity search, schema and sys.tables inspection, dacpac deployment, and Query Store, blocked sessions and regressed-plan investigation. Use for any query or change against a SQL database item. Warehouse, lakehouse SQL endpoint and mirrored items belong to sqldw-cli.

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

Expert knowledge for SQL Server on Azure Virtual Machines development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when planning SQL VM vs Managed Instance, Always On/FCI HADR, Azure storage/backups, Key Vault/Entra auth, or KQL telemetry, and other SQL Server on Azure Virtual Machines related development tasks. Not for Azure SQL Database (use azure-sql-database), Azure SQL Managed Instance (use azure-sql-managed-instance), Azure Virtual Machines (use azure-virtual-machines), Azure Data Science Virtual Machines (use azure-data-science-vm).

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

SQL injection occurs when untrusted user input is interpolated directly into database queries, allowing attackers to alter query logic. Detect via single-quote errors, boolean-based blind responses (AND 1=1 vs AND 1=2), time-delay payloads (SLEEP, WAITFOR), UNION column enumeration, and error messages from MySQL, Oracle, MSSQL, PostgreSQL. Tools: sqlmap, sqlbftools, Burp Suite, wfuzz with SQLi fuzz strings.

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

使用 AACT (Aggregate Analysis of ClinicalTrials.gov) PostgreSQL 数据仓库进行批量、历史、聚合性临床试验数据挖掘。Use this skill when the user requests bulk SQL analysis over the full clinical trials data warehouse — historical trial trends, disease landscapes, similar-design matching, or multi-year aggregations across hundreds of thousands of NCT records. 触发场景包括：AACT 查询、临床试验批量分析、PostgreSQL 试验数据、全量 NCT 检索、试验数据挖掘、历史试验分析、clinical trials data warehouse、SQL trials、bulk trial analysis、disease landscape、试验设计相似性匹配、跨年度聚合、sponsor/phase/country 多维统计。**与 clinical-trials-v2 差异**：本 skill 走批量 SQL · 离线大数据（PostgreSQL）；v2 走实时 API · 单查询。两者互补：单条 NCT 实时状态用 v2，百万级历史挖掘用本 skill。支持云端公共 PostgreSQL（aact-db.ctti-clinicaltrials.org · 零部署）和每日 dump 本地还原（高性能 · 离线）两种连接方式，自动检测优先用本地。跨平台（macOS/Linux/Windows）参数化 SQL 防注入，read-only 强制保护。

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

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.

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

Next.js + Better Auth + PostgreSQL を Docker で構築し、Cloud Run へデプロイするスキル。ローカル開発環境のセットアップから Docker Compose、Dockerfile 作成、Cloud Run + Cloud SQL + Secret Manager を使った本番デプロイまでをカバーする。「Next.js と Better Auth でアプリを作りたい」「Docker で PostgreSQL を使いたい」「Docker で構築したい」「Docker Compose を使いたい」「アプリを Docker 化したい」「Dockerfile を書きたい」「Cloud Run にデプロイしたい」「Cloud SQL や Secret Manager を使いたい」ときに使う。

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

Specialized skill for containerized database testing using Testcontainers. Use when testing real database behavior, using SQL Server/PostgreSQL/MySQL containers, testing EF Core/Dapper. Covers container startup, database migrations, test isolation, container sharing. Keywords: testcontainers, container testing, database testing, MsSqlContainer, PostgreSqlContainer, MySqlContainer, EF Core testing, Dapper testing, Testcontainers.MsSql, Testcontainers.PostgreSql, GetConnectionString, IAsyncLifetime, CollectionFixture

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

OpenClaw의 시작, 채팅, 화면 표시가 느린 원인을 작업 횟수와 실측값으로 조사합니다. 불필요한 처리를 줄이고 성능 개선 PR 작성과 검토를 지원합니다.

• 시작이나 채팅 응답 지연 조사
• 중복 SQL 실행과 파일 읽기 줄이기
• 실측값으로 성능 개선 PR 검토

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

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

API, 데이터베이스, 파일 처리를 AI 에이전트가 호출할 수 있는 MCP 서버로 구현합니다. Python 개발부터 로컬 검증, 클라이언트 등록, HTTP 공개까지 돕습니다.

• 기존 API를 AI 에이전트에 연결
• SQLite 읽기 전용 쿼리 제공
• 텍스트 파일 확인과 검색을 도구로 구현

Plan and implement a unified AgentDB memory backend for agents. Migrate SQLite and Markdown data, add HNSW indexing for similarity search, and support shared memory and SONA learning patterns while preserving compatibility with existing systems.

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

• Consolidating separate agent memory systems
• Migrating SQLite and Markdown data to AgentDB
• Finding stored information with similar meaning

Plan and implement a unified AgentDB memory backend for agents. Migrate SQLite and Markdown data, add HNSW indexing for similarity search, and support shared memory and SONA learning patterns while preserving compatibility with existing systems.

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

• Consolidating separate agent memory systems
• Migrating SQLite and Markdown data to AgentDB
• Finding stored information with similar meaning

Plan a former employee register covering previous roles, departure dates, rehire eligibility, and future contact dates. Receive a simple workflow recommendation, with empty CSV templates, SQL table definitions, JSON Schema, or Notion mappings available on request.

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

• Planning a former employee register
• Preparing a template for rehire candidates
• Organizing fields for future contact dates

Define a practical KPI dashboard, a view of key business measures, by organizing metric definitions, sources, formulas, periods, targets, and owners. Produces empty CSV, SQL, JSON Schema, or Notion import mappings when requested.

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

• Choose metrics for a business decision
• Review an overcrowded KPI dashboard
• Create a CSV register of metric definitions

Plan a 360-degree or peer feedback process and create empty response templates from confirmed requirements. Produces consistent CSV, SQL, JSON Schema, or Notion property mappings while keeping visibility choices and scoring configuration separate.

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

• Plan an anonymous peer feedback process
• Create a CSV template for feedback responses
• Align feedback fields across SQL and JSON Schema

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.

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

• Recording Oracle behavior before migration
• Testing repository methods and stored procedure calls
• Checking empty strings, NULL inputs, and datetime precision

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.

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

• Planning an Oracle-to-PostgreSQL migration across multiple projects
• Identifying Oracle dependencies in a .NET solution
• Deciding migration order based on project dependencies