Tag: database
Drizzle database migration best practices guide
This skill guides developers through generating and managing database schema migrations using Drizzle Kit. It emphasizes best practices for writing idempotent SQL, ensuring safe and repeatable schema evolution across various database operat…
Mini Program Document Database Access via CloudBase SDK
This skill provides structured access to the CloudBase document database specifically for WeChat Mini Programs. It facilitates full CRUD operations, complex querying, pagination, aggregation, and geolocation queries using the native wx.clou…
CloudBase Resource Management via CLI
This skill enables deterministic, scriptable, and auditable management of CloudBase resources using the tcb command-line interface. It supports deploying functions, managing databases, and configuring networking via CLI commands, making it …
Managing idempotent database schema migrations
This skill guides developers through generating, customizing, and optimizing database migrations using Drizzle Kit. It emphasizes best practices for writing idempotent SQL, ensuring schema changes are safe to re-run.
Diagnose backend bottlenecks using Django Silk data
Investigate slow endpoints and performance bottlenecks by querying Django Silk profiling data stored in PostgreSQL. This skill identifies query patterns, detects N+1 issues, and analyzes query plans to pinpoint whether the bottleneck is dat…
Structured Database Querying via Schema Exploration
This skill enforces an explore-then-query workflow, guiding the agent to first inspect database schemas and object structures using dedicated MCP tools before executing SQL statements. It ensures robust data retrieval by preventing guesswor…
testing dbhub connectors and utilities
This skill facilitates comprehensive testing of DBHub, covering unit tests using Vitest and complex integration tests leveraging Testcontainers for various database backends. It provides structured commands and debugging guidance for ensuri…
Neotoma SQLite Database Recovery Utility
This utility checks the integrity of Neotoma's SQLite database and, if corruption is detected, executes a recovery process. It generates a verified copy that can be manually swapped back into the live data directory.
Recover Neotoma SQLite Database Corruption
This utility addresses common SQLite corruption errors (e.g., `SQLITE_CORRUPT`) encountered with Neotoma's local database files. It generates a verified recovered copy, which must then be manually validated and swapped into the live databas…
Prisma ORM for Type-Safe Database Interactions
This skill guides the correct implementation of Prisma ORM, ensuring proper type safety and usage of generated clients and enums within a TypeScript environment. It facilitates robust database interactions with PostgreSQL.
Automating SQLite Storage Schema Migrations
This skill manages the lifecycle of SQLite storage schema evolution by generating forward-only, idempotent migrations. It guides the developer through identifying schema deltas, implementing safe SQL changes, and registering updates to keep…
Comprehensive database introspection and schema querying
This skill provides comprehensive introspection into a live database binding, allowing developers to query schema details, foreign keys, row-level security policies, and stored procedures. It offers granular tools for verifying connectivity…
Deep database introspection and schema querying tool
This tool suite provides deep introspection into a live database binding, allowing developers to query schema details, foreign key relationships, row-level security policies, and stored procedure definitions. It is essential for verifying c…
Database introspection and schema querying tool
This suite of tools provides deep introspection into a connected database, allowing developers to query schema details, foreign keys, row-level security policies, and stored procedures. It offers granular access to metadata, including table…
Database introspection and schema querying skill
This skill provides comprehensive introspection into a connected database, allowing the agent to query table schemas, foreign key relationships, row-level security policies, and stored procedure definitions. It is ideal for understanding th…
Hologres Database Management and Query Tool
This CLI provides comprehensive interaction with the Hologres database, enabling developers to execute DDL, DML, and SELECT queries, analyse query plans, and manage resources like schemas and dynamic tables. It also supports generating char…
NocturnusAI System Administration API Manager
This tool provides comprehensive REST-only access for managing the NocturnusAI platform, allowing developers to perform database, tenant, and API key lifecycle operations. It facilitates critical administrative tasks such as RBAC configurat…
Wren Engine CLI - Agent Workflow Guide
This skill provides a workflow guide for AI agents using the Wren Engine CLI to query databases. It covers version checking, environment verification, SQL writing and execution, error recovery, and memory management, enabling agents to answ…