1426 个 · 按相关度排序
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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精确统计数量和排名。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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).
中文简介正在准备中。当前显示原文说明。
Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities. This skill MUST be invoked when the user mentions: "DBSQL", "Databricks SQL", "SQL warehouse", "SQL scripting", "stored procedure", "CALL procedure", "materialized view", "CREATE MATERIALIZED VIEW", "pipe syntax", "|>", "geospatial", "H3", "ST_", "spatial SQL", "collation", "COLLATE", "ai_query", "ai_classify", "ai_extract", "ai_gen", "AI function", "http_request", "remote_query", "read_files", "Lakehouse Federation", "recursive CTE", "WITH RECURSIVE", "multi-statement transaction", "temp table", "temporary view", "pipe operator". SHOULD also invoke when the user asks about SQL best practices, data modeling patterns, or advanced SQL features on Databricks.
中文简介正在准备中。当前显示原文说明。
搜索本地保存的Notion页面，查看数据库列表、报告和同步状态，用只读SQL统计页面数量，并在需要时更新数据或导出Markdown文件。
Analyze and tune PostgreSQL databases using query execution plans, which show how queries run. This skill guides index design, JSONB searches, replication setup, maintenance, and monitoring, with checks to compare behavior before and after changes.
中文简介正在准备中。当前显示英语简介。