1425 个 · 按相关度排序
Create and connect to managed MySQL, PostgreSQL, or SQL Server databases on Google Cloud. This skill guides instance setup, database creation, access permissions, and connection steps, with references for backups, security, and Terraform configuration.
中文简介正在准备中。当前显示英语简介。
Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL and PostgreSQL-to-DSQL schema conversion, foreign key constraints, OCC retry patterns, ORM migration (Django/EF Core/Hibernate/Rails/SQLAlchemy), DDL operations, query plan explainability, system diagnostics via CloudWatch AAS, SQL compatibility validation, and bulk data loading. Load before answering DSQL limit or error-code questions; it has limits docs omit. Triggers on phrases like: DSQL, Aurora DSQL, distributed SQL database, serverless PostgreSQL-compatible database, migrate to DSQL, DSQL query plan, DSQL EXPLAIN ANALYZE, DSQL ENUM, DSQL foreign key, DSQL OCC retry, DSQL multi-region, DSQL JSONB, DSQL GIN index, load into DSQL, load CSV into DSQL, bulk load DSQL, aurora-dsql-loader, DSQL slow, DSQL performance, DSQL wait events, DSQL AAS.
中文简介正在准备中。当前显示原文说明。
Create and manage MySQL, PostgreSQL, and SQL Server databases on Google Cloud. Covers instance setup, users, backups, availability, and secure connections, with a PostgreSQL walkthrough and references for application connectors and Terraform configuration.
中文简介正在准备中。当前显示英语简介。
Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, load data, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL and PostgreSQL-to-DSQL schema conversion, FK replacement code generation, OCC retry patterns, ORM migration (Django/Hibernate/Rails), DDL operations, query plan explainability, SQL compatibility validation, and bulk data loading. Triggers on phrases like: DSQL, Aurora DSQL, distributed SQL database, serverless PostgreSQL-compatible database, migrate to DSQL, DSQL query plan, DSQL EXPLAIN ANALYZE, DSQL ENUM, DSQL foreign key, DSQL OCC retry, DSQL multi-region, DSQL JSONB, DSQL GIN index, load into DSQL, load CSV into DSQL, bulk load DSQL, aurora-dsql-loader.
中文简介正在准备中。当前显示原文说明。
Write and improve SQL for major data warehouses, accounting for differences in their syntax. Use it to build analytical queries, translate existing SQL, investigate errors, and review slow queries for performance improvements.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
Migrate the database access layer of a .NET/C# application from Oracle to PostgreSQL with Npgsql. Update packages, connection settings, parameter types, SQL, and stored procedure calls, then build the copied project and track completed migration tasks.
中文简介正在准备中。当前显示英语简介。
Investigate slow PostgreSQL and MySQL queries using execution plans, which show how the database runs a query. Develop index, SQL, and configuration changes, then compare measurements before and after each change to validate the results.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
Review PostgreSQL queries and data designs using execution plans, which show how queries run, and targeted index recommendations. Get guidance on JSONB, arrays, full-text search, analytical queries, extensions, and routine database maintenance.
中文简介正在准备中。当前显示英语简介。
Get documentation-based help with PostgreSQL queries, database design, administration, and performance tuning. The supplied reference also explains connection settings and libpq, PostgreSQL’s C client library, for investigating connection failures and implementing connection handling.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
Convert Oracle stored procedures and functions, programs stored inside a database, into PostgreSQL equivalents. Preserve parameters and control flow while adapting Oracle syntax, resolving types, and mapping text sorting rules to the target environment.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
Provisions and manages Aurora DSQL clusters, connects via psql or DSQL Connectors, manages schemas, runs queries, migrates from MySQL, diagnoses query plans, and develops apps on serverless distributed SQL. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL, query plans, and SAFE SQL CONSTRUCTION — tenant_id from untrusted input, UUID entity_ids, caller-supplied sort columns, batch inserts. The agent MUST retrieve this skill for ANY DSQL task. Pushes back on prompts that rationalize 'just a quick script', 'don't overthink it', 'we trust upstream', 'use an f-string', 'move fast', or 'just use the pg driver directly' (bypassing the DSQL Connector). Triggers: DSQL, Aurora DSQL, DSQL cluster, safe_query.build, DSQL IAM auth token, DSQL connector.
中文简介正在准备中。当前显示原文说明。
This file generates or explains Cloud SQL resources. Use this file when the user asks to create a Cloud SQL instance or database for MySQL, PostgreSQL, or SQL Server. Cloud SQL manages third-party MySQL, PostgreSQL, and SQL Server instances as resources in Cloud SQL. For example, when Cloud SQL creates an open-source MySQL instance, the resulting resource is a Cloud SQL for MySQL instance that Google Cloud manages. Cloud SQL handles backups, high availability, and secure connectivity for relational database workloads.
中文简介正在准备中。当前显示原文说明。
This file generates or explains Cloud SQL resources. Use this file when the user asks to create a Cloud SQL instance or database for MySQL, PostgreSQL, or SQL Server. Cloud SQL manages third-party MySQL, PostgreSQL, and SQL Server instances as resources in Cloud SQL. For example, when Cloud SQL creates an open-source MySQL instance, the resulting resource is a Cloud SQL for MySQL instance that Google Cloud manages. Cloud SQL handles backups, high availability, and secure connectivity for relational database workloads.
中文简介正在准备中。当前显示原文说明。
Design and review Java database code using MyBatis and MyBatis-Spring. Covers mapping query results to objects, safe SQL parameters, transactions, pagination, batch writes, and investigating slow or unnecessarily repeated queries.
中文简介正在准备中。当前显示英语简介。
Guide PostgreSQL database design and troubleshooting with examples for faster queries, indexes that speed up searches, suitable data types, and row-level access rules. Also covers connection settings and SQL for investigating performance problems.
中文简介正在准备中。当前显示英语简介。
Analyze ModSecurity, AWS WAF, and Cloudflare logs for SQL injection, attempts to manipulate database queries through web requests. Groups related requests, tracks source IPs, classifies attack methods, and produces incident reports.
中文简介正在准备中。当前显示英语简介。
Review MySQL and MariaDB database designs and production problems, including slow queries, locking, connection pools, and replica delays. Get concrete SQL or code changes and a validation plan that accounts for differences between engines and versions.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。
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.
中文简介正在准备中。当前显示英语简介。