'sql' 검색 결과

Review pending database migration SQL before applying schema changes. Check references between tables, rollback coverage, required defaults, destructive operations, and naming conventions, then report errors, warnings, and suggestions with file paths and line numbers.

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

• Reviewing database migrations before applying them
• Checking foreign key targets and migration order
• Checking rollback SQL for missing operations

Write and review SQL for reports and metrics in a data warehouse, a store of analytical data. Applies rules for explicit columns, date filters, aggregate names, and limited exploratory results, returning SQL with a brief explanation.

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

• Write SQL for report and dashboard metrics
• Calculate counts, sums, and rolling metrics
• Combine data from multiple tables

Investigate slow SQL using execution plans, which show how a database processes a query. Review indexes, filters, joins, and maintenance practices through PostgreSQL examples to identify bottlenecks and plan changes to queries or database structure.

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

• Investigating slow SQL queries
• Reviewing index choices and column order
• Reading EXPLAIN execution plans

Provision a PostgreSQL database with Neon Instagres and save connection settings for application use and migrations. Includes setup examples for Drizzle and Prisma, initial data loading, and claiming a temporary database to keep using it.

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

• Provision a PostgreSQL database for development
• Configure database access with Drizzle or Prisma
• Load a SQL file with initial data

Guide SQLite database design and performance tuning for applications. Covers concurrent reads and writes, indexes that speed up queries, full-text search, JSON processing, analytical queries, and versioned changes to database structure.

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

• Investigating slow SQLite queries
• Reducing contention between database reads and writes
• Designing full-text search and JSON queries

Create paired SQL files for applying and reversing database structure changes. Determine the next sequence number from existing migrations, choose a template based on the change name, and record metadata with the migration marked as pending.

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

• Prepare SQL files for creating a table
• Create paired migrations for adding a column
• Prepare a migration to add an index

Review database structures and relationships, identify design issues, and generate relationship diagrams. The skill recommends indexes, which help queries find data efficiently, and prepares migration steps with validation and rollback planning.

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

• Reviewing table structures and relationships
• Improving indexes for frequent queries
• Planning database changes without downtime

Import SaaS data into DuckDB using dlt, a data loading tool, then generate a Wren project with table definitions and relationships. Verify the setup with real SQL queries, or start from an existing DuckDB file.

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

• Importing HubSpot or Stripe data for SQL analysis
• Creating a Wren project from an existing dlt DuckDB file
• Generating table definitions and parent-child relationships

Reads from, writes to, and manages relational databases using MATLAB Database Toolbox. Use when connecting to databases, reading data with sqlread or fetch, filtering with rowfilter, writing with sqlwrite, updating with sqlupdate, executing SQL statements, managing transactions with commit and rollback, mapping MATLAB classes to tables with ORM (Mappable, ormread, ormwrite, ormupdate), or performing any database operation from MATLAB. Triggers on: database, SQL, sqlread, sqlwrite, sqlupdate, fetch, execute, rowfilter, RowFilter, ORM, Mappable, ormread, ormwrite, ormupdate, orm2sql, transaction, commit, rollback, Database Toolbox, PostgreSQL, MySQL, SQLite, SQL Server, Oracle, database connection, database table, query database, insert data, update rows, delete rows, stored procedure, prepared statement, odbc, databaseConnectionOptions, datasource, data source, DSN, connection string, multithreaded, parallel.

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

Execute advanced SQL Injection attacks to bypass WAFs and extract data from complex architectures. Use this skill for Boolean-Based Blind, Time-Based Blind, Second-Order SQLi, and Out-of-Band (OOB) SQLi across MySQL, PostgreSQL, MSSQL, and Oracle.

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

Design and review PostgreSQL database schemas by choosing suitable column types, keys, constraints, and indexes. It also guides decisions about large-table partitioning, flexible JSONB data, and schema changes on a live database without downtime.

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

• Designing or reviewing a new PostgreSQL schema
• Choosing data types, constraints, and indexes
• Planning partitions for a large table

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

Create and work with Google Bigtable instances and tables, design row keys and column groups, and query data with SQL or client libraries. Investigate slow queries and concentrated access patterns using Key Visualizer and command-line diagnostics.

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

• Designing row keys and column families
• Creating Bigtable instances and tables
• Writing SQL queries or data access code

Expert knowledge for Azure Database for MySQL development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when planning MySQL Flexible Server tiers, HA/DR, automated deployments, backups/replication, or secure app connectivity, and other Azure Database for MySQL 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 PostgreSQL (use azure-database-postgresql).

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

Granola 로컬 보관 자료에서 회의 메모, 녹취록, 패널을 검색하고 가져옵니다. 동기화 상태를 확인하고 필요할 때 갱신하며, 읽기 전용 SQL로 정확한 개수와 순위를 구합니다.

• 주제로 지난 회의 메모 찾기
• 메모의 녹취록과 패널 가져오기
• 최근 정보 검색 전 동기화 상태 확인

Perl 코드의 입력 처리, 파일 작업, 외부 명령, SQL과 웹 출력을 점검합니다. 구체적인 예시와 점검표에 따라 안전한 구현으로 수정합니다.

• Perl 입력 검증을 점검합니다
• 파일 작업과 명령 실행을 확인합니다
• DBI의 SQL 삽입 공격에 대비합니다

Assess database security within an authorized scope by reviewing network exposure, authentication, access permissions, risky features, audit logs, and backup access. Distinguish configuration weaknesses from issues that can be demonstrated through safe validation.

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

• Reviewing database exposure and TLS settings
• Checking account privileges and sensitive table access
• Assessing dangerous features and configuration weaknesses

Review PostgreSQL code for database design, performance, and security issues. Get improvement suggestions covering JSONB, a binary JSON format, arrays, indexes, custom data types, functions, extensions, and rules that control access to individual rows.

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

• Reviewing JSONB and array queries
• Checking table types and constraints
• Improving functions and triggers

Guides Postgres query writing, schema design, and configuration reviews using Supabase's prioritized rules. Helps identify improvements in query performance, connection management, and row-level security, which controls access to individual rows.

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

• Review slow SQL queries and index usage
• Check table and schema designs
• Review connection pooling and scaling settings

Helps design ClickHouse tables, write analytical queries, and build data ingestion workflows. Covers batch inserts, precomputed summaries, and performance monitoring for teams working with large datasets and time-based activity analysis.

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

• Designing tables for large analytical datasets
• Improving slow aggregation queries
• Analyzing user retention and conversion steps

Improve PostgreSQL performance through a staged workflow covering slow query analysis, indexes that speed up data access, query rewrites, configuration tuning, routine maintenance, and monitoring for production databases.

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

• Investigating slow PostgreSQL queries
• Reviewing database indexes
• Tuning database configuration

Use persistent virtual terminal sessions to keep directories and environment variables across commands, interact with Python or database consoles, and answer prompts. The skill explains sending input, reading responses, detecting prompts, and closing sessions when finished.

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

• Keep directories and environment variables across commands
• Run a sequence of commands in an interactive Python console
• Interact with mysql or psql consoles

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 search, managed identities, Private Link/TLS, or PITR/geo-restore, 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).

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