redis-caching-patterns
Redis caching strategies for MCP servers - cache invalidation, TTL management, pub/sub patterns, and performance optimization
Redis caching strategies for MCP servers - cache invalidation, TTL management, pub/sub patterns, and performance optimization
List all vector namespaces. Requires authentication. Use for Agentuity cloud platform operations
MongoDB database development - queries, aggregations, schema analysis using MCP tools
Manage LibSQL/Turso database schemas with Zod validation, create migrations, and ensure type-safe database operations.
Use this when changing the database schema, generating/applying Drizzle migrations for Cloudflare D1 (SQLite), or working with Better Auth schema generation.
Add, manage, and execute SQL scripts in self-hosted Metabase via REST API. Supports creating cards/questions, running queries, and managing collections. Use when: Creating Metabase dashboards programmatically, automating report generation, managing SQL questions/cards via API, or integrating Metabase with the casino platform.
Use before implementing pgdbm patterns to avoid common mistakes - provides rationalization table and red flags that prevent pool multiplication, schema errors, and template syntax violations
Write effective, type-safe Kysely queries for PostgreSQL. This skill should be used when working in Node.js/TypeScript backends with Kysely installed, covering query patterns, migrations, type generation, and common pitfalls to avoid.
Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or CloudKit private database sync.
PostgreSQL MCPใงในใญใผใ็ขบ่ชใจread-onlyๅๆใ่กใใ้่จใปๆๆๆฑบๅฎ่ณๆใๅฟ ่ฆใชๆใซไฝฟใใ
Write efficient and secure database queries using parameterized queries, eager loading to prevent N+1 problems, selective column fetching, strategic indexing, transactions for related changes, query timeouts, and caching for expensive queries. Use this skill when writing Eloquent queries or raw SQL, optimizing database performance, preventing N+1 query problems with eager loading, implementing database transactions, adding indexes to improve query speed, or caching frequently-run queries. This skill applies when working with Eloquent query builder, raw database queries, query optimization, or any code that interacts with the database.
Neo4j driver best practices for Python. Use when working with Neo4j connections, Cypher queries, transactions, or GraphRAG implementations.
Analyze and optimize Django ORM queries including N+1 problems, missing indexes, slow queries, and migration issues. Use when troubleshooting slow API responses, database performance, query optimization, or migration errors.
ใทใฃใผใใฃใณใฐๅฏพๅฟใฎใณใผใใๆธใ้ใซไฝฟ็จใuser_idใใผในใฎhash shardingใใใผใใซๅๅฒใใฏใญในใทใฃใผใใฏใจใชใRepositoryๅฎ่ฃ ๆใซ่ชๅ้ฉ็จใใทใฃใผใใฃใณใฐใๅๆฃDBใใใผใใซๅๅฒใใฏใญในDBใฏใจใชใๆฑใๅ ดๅใซไฝฟ็จใ
Execute SQL query on a database. Requires authentication. Use for Agentuity cloud platform operations
Execute PostgreSQL queries against the Supabase database using psql with 1Password credential retrieval
Building database queries with the Options API. Use when you need to query a model by creating a new query or updating an existing one
ๆฅ่ฏข้ๆ่ฟๆฅๅจๅAPI้ ็ฝฎ๏ผv3_openapiๆฐๆฎๅบ๏ผใไฝฟ็จ exec_sql ๅทฅๅ ทๆง่กๆฅ่ฏขใ
Design and implement production-grade database layers using SQLModel with SQLAlchemy 2.0 patterns. This skill should be used when users need to create database models, configure engines/sessions, design schemas, implement relationships, or optimize database performance in Python FastAPI projects.