Database

Database management and queries

Showing 1753-1776 of 3661 skills
armanzeroeight

schema-designer

by armanzeroeight

Design database schemas with proper normalization, relationships, constraints, and indexes. Use when creating database tables, modeling data relationships, or designing database structure.

Code Gen 29 8mo ago
greyhaven-ai

grey-haven-data-validation

by greyhaven-ai

"Comprehensive data validation using Pydantic v2 with data quality monitoring and schema alignment for PlanetScale PostgreSQL. Use when implementing API validation, database schema alignment, or data quality assurance. Triggers: 'validation', 'Pydantic', 'schema', 'data quality'."

Processing 29 7mo ago
armanzeroeight

query-optimizer

by armanzeroeight

Optimize SQL queries for performance with indexing strategies, query rewriting, and execution plan analysis. Use when queries are slow, optimizing database performance, or analyzing query execution.

Code Gen 29 8mo ago
greyhaven-ai

grey-haven-database-conventions

by greyhaven-ai

"Apply Grey Haven database conventions - snake_case fields, multi-tenant with tenant_id and RLS, proper indexing, migrations for Drizzle (TypeScript) and SQLModel (Python). Use when designing schemas, writing database code, creating migrations, setting up RLS policies, or when user mentions 'database', 'schema', 'Drizzle', 'SQLModel', 'migration', 'RLS', 'tenant_id', 'snake_case', 'indexes', or 'foreign keys'."

Code Gen 29 7mo ago
armanzeroeight

gcp-cost-optimizer

by armanzeroeight

Analyzes GCP costs and provides optimization recommendations including committed use discounts, rightsizing, and unused resources. Use when optimizing GCP spending or analyzing GCP costs.

Cloud 29 7mo ago
armanzeroeight

state-management-advisor

by armanzeroeight

Choose and implement React state management solutions including Context, Zustand, Redux Toolkit, TanStack Query, and Jotai. Use when selecting state management, implementing global state, or managing server state in React applications.

Processing 29 8mo ago
greyhaven-ai

grey-haven-code-style

by greyhaven-ai

"Apply Grey Haven Studio's TypeScript/React and Python/FastAPI coding standards from production templates. Use when writing code, reviewing PRs, fixing linting errors, formatting files, or when the user mentions 'code standards', 'Grey Haven style', 'linting', 'Prettier', 'ESLint', 'Ruff', 'formatting rules', or 'coding conventions'. Includes exact Prettier/ESLint/Ruff configs, naming conventions, project structure, and multi-tenant database patterns."

Database 29 7mo ago
armanzeroeight

matrix-optimizer

by armanzeroeight

Optimize GitHub Actions matrix strategies for testing across multiple versions, platforms, and configurations. Use when configuring matrix builds, testing multiple versions, cross-platform testing, or optimizing CI resource usage. Trigger words include "matrix strategy", "test matrix", "multiple versions", "cross-platform".

Database 29 7mo ago
greyhaven-ai

grey-haven-ontological-documentation

by greyhaven-ai

Create comprehensive ontological documentation for Grey Haven systems - extract domain concepts from TanStack Start and FastAPI codebases, model semantic relationships, generate visual representations of system architecture, and document business domains. Use when onboarding, documenting architecture, or analyzing legacy systems.

Auth 29 7mo ago
armanzeroeight

test-generator

by armanzeroeight

Generates dbt tests including schema tests, data quality tests, and freshness checks. Use when adding tests to dbt models or implementing data quality validation.

Database 29 7mo ago
leegonzales

goals-graph

by leegonzales

Query and update Lee's goals graph through natural language. Translates conversational questions and updates into goals_query.py commands.

Analytics 29 5mo ago
armanzeroeight

model-builder

by armanzeroeight

Creates dbt models with proper layering (staging, marts), incremental strategies, and documentation. Use when creating dbt models, organizing data transformations, or implementing incremental models.

Processing 29 7mo ago
greyhaven-ai

grey-haven-data-modeling

by greyhaven-ai

Design database schemas for Grey Haven multi-tenant SaaS - SQLModel models, Drizzle schema, multi-tenant isolation with tenant_id and RLS, timestamp fields, foreign keys, indexes, migrations, and relationships. Use when creating database tables.

Code Gen 29 7mo ago
armanzeroeight

azure-cost-optimizer

by armanzeroeight

Analyzes Azure costs and provides optimization recommendations including reserved instances, rightsizing, and unused resources. Use when optimizing Azure spending or analyzing Azure costs.

Cloud 29 7mo ago
greyhaven-ai

grey-haven-tanstack-patterns

by greyhaven-ai

"Apply Grey Haven's TanStack ecosystem patterns - Router file-based routing, Query data fetching with staleTime, and Start server functions. Use when building React applications with TanStack Start. Triggers: 'TanStack', 'TanStack Start', 'TanStack Query', 'TanStack Router', 'React Query', 'file-based routing', 'server functions'."

Processing 29 7mo ago
armanzeroeight

security-group-analyzer

by armanzeroeight

Audit AWS security groups for overly permissive rules and security vulnerabilities. Use when reviewing AWS security, auditing security groups, or improving network security posture.

Cloud 29 8mo ago
armanzeroeight

database-migration-helper

by armanzeroeight

Create and manage database migrations safely with rollback support. Use when modifying database schema, adding indexes, or managing database changes.

Code Gen 29 8mo ago
KhaiHuynhVN

Project Scanner Workflow

by KhaiHuynhVN

Code Review 29 6mo ago
greyhaven-ai

grey-haven-react-tanstack-testing

by greyhaven-ai

"Specialized testing for React applications using TanStack ecosystem (Query, Router, Table, Form) with Vite and Vitest. Use when testing React + TanStack apps, mocking server state, testing router, or validating query behavior. Triggers: 'TanStack testing', 'React Query testing', 'test TanStack', 'mock query', 'router test'."

Database 29 7mo ago
Demerzels-lab

sushiswap-api

by Demerzels-lab

REST API for optimized token swapping (including executable transaction generation), swap quoting, and pricing using the SushiSwap Aggregator. Use this skill when the user wants to: - Get a swap quote between two tokens on 40+ evm networks - Generate executable swap transaction data - Fetch token prices for a specific network or token - Retrieve token metadata - Discover supported AMM liquidity sources - Integrate SushiSwap swapping or pricing logic via HTTP/REST (and not the SushiSwap Javascript API)

API Dev 10 5mo ago
Demerzels-lab

database

by Demerzels-lab

Database management and queries. Connect to SQL and NoSQL databases, run queries, and manage schemas.

Caching 10 5mo ago
Demerzels-lab

binance

by Demerzels-lab

Binance exchange integration. Trade spot, futures, and manage portfolio on the world's largest crypto exchange.

API Dev 10 5mo ago
kevintsengtw

dotnet-testing-advanced-testcontainers-database

by kevintsengtw

使用 Testcontainers 進行容器化資料庫測試的專門技能。當需要測試真實資料庫行為、使用 SQL Server/PostgreSQL/MySQL 容器、測試 EF Core/Dapper 時使用。涵蓋容器啟動、資料庫遷移、測試隔離、容器共享等。 Keywords: testcontainers, 容器測試, container testing, database testing, 資料庫測試, MsSqlContainer, PostgreSqlContainer, MySqlContainer, EF Core testing, Dapper testing, Testcontainers.MsSql, Testcontainers.PostgreSql, GetConnectionString, IAsyncLifetime, CollectionFixture

Automation 28 5mo ago
kevintsengtw

dotnet-testing-advanced-aspire-testing

by kevintsengtw

.NET Aspire Testing 整合測試框架完整指南。當需要測試 .NET Aspire 分散式應用程式、設定 AppHost 測試或從 Testcontainers 遷移至 Aspire 測試時使用。涵蓋 DistributedApplicationTestingBuilder、容器生命週期管理、多服務編排、Respawn 配置與時間可測試性設計。 Keywords: aspire testing, .NET Aspire, DistributedApplicationTestingBuilder, AppHost testing, 分散式測試, AspireAppFixture, IAsyncLifetime, ContainerLifetime.Session, 雲原生測試, 多服務整合, Aspire.Hosting.Testing, Respawn

Code Gen 28 5mo ago