Database

Database management and queries

Showing 1441-1464 of 4352 skills
akin-ozer

promql-validator

by akin-ozer

Comprehensive toolkit for validating, optimizing, and understanding Prometheus Query Language (PromQL) queries. Use this skill when working with PromQL queries to check syntax, detect anti-patterns, identify optimization opportunities, and interactively plan queries with users.

Database 327 8mo ago
udecode

convex

by udecode

ALWAYS use this skill when working with convex or better-convex. Covers the common end-to-end feature path using cRPC + ORM + auth + React, with setup/bootstrap and niche depth in references.

Auth 452 7mo ago
waynesutton

convex-best-practices

by waynesutton

Guidelines for building production-ready Convex apps covering function organization, query patterns, validation, TypeScript usage, error handling, and the Zen of Convex design philosophy

Database 405 8mo ago
waynesutton

convex-functions

by waynesutton

Writing queries, mutations, actions, and HTTP actions with proper argument validation, error handling, internal functions, and runtime considerations

API Dev 405 8mo ago
waynesutton

convex

by waynesutton

Umbrella skill for all Convex development patterns. Routes to specific skills like convex-functions, convex-realtime, convex-agents, etc.

Code Review 405 9mo ago
waynesutton

convex-schema-validator

by waynesutton

Defining and validating database schemas with proper typing, index configuration, optional fields, unions, and migration strategies for schema changes

Database 405 9mo ago
waynesutton

convex-component-authoring

by waynesutton

How to create, structure, and publish self-contained Convex components with proper isolation, exports, and dependency management

Database 405 9mo ago
waynesutton

convex-migrations

by waynesutton

Schema migration strategies for evolving applications including adding new fields, backfilling data, removing deprecated fields, index migrations, and zero-downtime migration patterns

Code Gen 405 9mo ago
unclecatvn

odoo-18

by unclecatvn

Odoo 18 development knowledge base with 18 specialized guides covering Actions (ir.actions.*, cron jobs, server actions), Controllers (HTTP routing, endpoints, auth types), Data files (XML/CSV records, shortcuts, noupdate), API Decorators (@api.depends, @api.constrains, @api.ondelete, @api.onchange, @api.model), Module development (manifest, wizards, reports), Field types (Char, Text, Monetary, relational fields), Manifest configuration (manifest.py, dependencies, asset bundles), Mixins (mail.thread, mail.activity.mixin, mail.alias.mixin, utm.mixin), ORM Model methods (search, CRUD, domain filters, recordsets, prefetch), Migration scripts (pre/post/end hooks, data migration), OWL frontend components (hooks, services, lifecycle), Performance optimization (N+1 prevention, batch ops, read_group), QWeb Reports (PDF/HTML, paper formats, barcodes), Security/ACL (record rules, field permissions, multi-company), Testing (TransactionCase, HttpCase, mocking, query count assertions), Transactions (savepoints, UniqueViolation, serialization failures), Translations (i18n, PO files, translatable fields), XML Views (list/form/search, xpath inheritance, QWeb templates). Use when writing, reviewing, or debugging any Odoo 18 Python or XML code, creating or modifying modules, fixing performance issues, or looking up Odoo 18 API patterns and best practices.

API Dev 147 8mo ago
maroffo

notion-sync

by maroffo

"Sync Notion workspace to Obsidian vault with AI summaries. Use when user says notion sync, sync notion, pull from notion, push to notion, or /notion-sync. Not for direct Obsidian vault operations (use obsidian skill)."

CI/CD 17 8mo ago
maroffo

email-cleanup

by maroffo

Clean up Gmail - archive old emails, delete promotions, manage storage. Use when user wants to clean inbox, archive emails, or free up space.

Automation 17 8mo ago
w-winter

gdcli

by w-winter

Google Drive CLI for listing, searching, uploading, downloading, and sharing files and folders.

Auth 139 9mo ago
adaptyvbio

uniprot

by adaptyvbio

Access UniProt for protein sequence and annotation retrieval. Use this skill when: (1) Looking up protein sequences by accession, (2) Finding functional annotations, (3) Getting domain boundaries, (4) Finding homologs and variants, (5) Cross-referencing to PDB structures. For structure retrieval, use pdb. For sequence design, use proteinmpnn.

API Dev 170 9mo ago
adaptyvbio

foldseek

by adaptyvbio

Structure similarity search with Foldseek. Use this skill when: (1) Finding similar structures in PDB/AFDB databases, (2) Structural homology search, (3) Database queries by 3D structure, (4) Finding remote homologs not detected by sequence, (5) Clustering structures by similarity. For sequence similarity, use uniprot BLAST. For structure prediction, use chai or boltz.

Database 170 9mo ago
ruan-cat

openspec

by ruan-cat

OpenSpec 规范驱动开发助手 - 基于 OPSX 工作流的 AI 辅助编程框架。在编写代码前与 AI 就需求达成一致,使用 Schema 驱动的工件依赖系统管理变更。 触发条件: 1. 用户提及 "openspec"、"opsx"、规范驱动开发 2. 用户想要开始新功能开发或重构 3. 用户需要探索复杂问题或明确需求 4. 用户抱怨 AI 理解偏差或频繁返工 5. 用户使用斜杠命令如 /opsx:new、/opsx:ff、/opsx:apply 等 6. 项目初始化或准备重大变更时

Code Gen 5 8mo ago
neutree-ai

日本語テストapi

by neutree-ai

Japanese character filename test. Use when working with the 日本語テストAPI or when the user needs to interact with this API.

API Dev 342 8mo ago
AltimateAI

optimizing-query-by-id

by AltimateAI

Optimizes Snowflake query performance using query ID from history. Use when optimizing Snowflake queries for: (1) User provides a Snowflake query_id (UUID format) to analyze or optimize (2) Task mentions "slow query", "optimize", "query history", or "query profile" with a query ID (3) Analyzing query performance metrics - bytes scanned, spillage, partition pruning (4) User references a previously run query that needs optimization Fetches query profile, identifies bottlenecks, returns optimized SQL with expected improvements.

Processing 129 9mo ago
AltimateAI

optimizing-query-text

by AltimateAI

Optimizes Snowflake SQL query performance from provided query text. Use when optimizing Snowflake SQL for: (1) User provides or pastes a SQL query and asks to optimize, tune, or improve it (2) Task mentions "slow query", "make faster", "improve performance", "optimize SQL", or "query tuning" (3) Reviewing SQL for performance anti-patterns (function on filter column, implicit joins, etc.) (4) User asks why a query is slow or how to speed it up

Database 129 9mo ago
neutree-ai

swagger-petstore-openapi-3-0

by neutree-ai

This is a sample Pet Store Server based on the OpenAPI 3.0 specification. You can find out more about. Use when working with the Swagger Petstore - OpenAPI 3.0 or when the user needs to interact with this API.

API Dev 342 9mo ago
spring-ai-alibaba

http-generate

by spring-ai-alibaba

Generates HTTP request examples for Spring Boot Web interfaces according to task specification and saves them as .http files in module-generate.md directories

API Dev 2.9K 10mo ago
tanweai

vuln-analysis-expert

by tanweai

WooYun漏洞分析专家系统。基于88,636个真实漏洞案例提炼的元思考方法论、测试流程、利用技巧、绕过方法。覆盖SQL注入、XSS、命令执行、逻辑漏洞、文件上传、未授权访问等主要漏洞类型。当用户进行漏洞挖掘、渗透测试、安全审计、代码审计时触发。

CLI Tools 1.8K 9mo ago
pinecone-io

pinecone:query

by pinecone-io

Query integrated indexes using text with Pinecone MCP. IMPORTANT - This skill ONLY works with integrated indexes (indexes with built-in Pinecone embedding models like multilingual-e5-large). For standard indexes or advanced vector operations, use the CLI skill instead. Requires PINECONE_API_KEY environment variable and Pinecone MCP server to be configured.

Database 69 7mo ago
einverne

postgresql-psql

by einverne

Comprehensive guide for PostgreSQL psql - the interactive terminal client for PostgreSQL. Use when connecting to PostgreSQL databases, executing queries, managing databases/tables, configuring connection options, formatting output, writing scripts, managing transactions, and using advanced psql features for database administration and development.

CLI Tools 121 10mo ago
einverne

code-reviewer

by einverne

进行系统化的代码审查,检查代码质量、安全性和性能。当用户要求审查代码、review 或检查代码时使用

API Dev 121 9mo ago