Tag: sql
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…
Django Silk Profiler for Backend Performance Analysis
This skill guides the investigation of slow Django endpoints by querying Django Silk profiling data. It helps diagnose bottlenecks by analysing SQL query patterns, identifying N+1 issues, and examining query execution plans.
Manage CloudBase Relational Database via MCP
This skill enables agents to manage the full lifecycle of a CloudBase Relational Database instance via MCP tools. It supports executing read/write SQL statements, provisioning/destroying MySQL, and managing granular resource permissions.
CloudBase Relational Database SQL Management Tool
This skill provides agents with canonical access to CloudBase's relational database via MCP tools, enabling full lifecycle management from provisioning and schema initialization to complex read and write operations. It also handles granular…
Manage Cursor Ambassador status via Supabase
This skill manages the Cursor Ambassador badge status within the Supabase user directory. It resolves a user via name, email, or UUID, handles potential ambiguities, and updates the is_ambassador flag using SQL.
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.
Wren Engine CLI Agent Workflow
An agentic workflow for performing end-to-end data analysis using the Wren Engine CLI. It enables agents to query databases via an MDL semantic layer and manage semantic memory for context retrieval and query storage.
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…
recovering corrupted neotoma sqlite databases
This procedure guides the recovery of Neotoma's underlying SQLite database when integrity errors, such as malformed disk images, are encountered. It generates a verified recovered copy which must then be manually swapped into the live data …
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.
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…
Mako Database Introspection Skill
Enables direct database introspection for inspecting schemas, foreign keys, row-level security policies, and RPC definitions. It allows developers to verify connectivity and examine detailed table constraints and structures.
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…
Query and analyze local Slack archives
This CLI tool provides comprehensive access to local Slack archive data, enabling users to search messages, check data freshness, and execute read-only SQL queries against workspace data.
Local Notion Archive Querying and Syncing
This tool provides read-only access to a local Notion archive, enabling developers to query cached data, check freshness, and sync content without making live API calls. It supports structured searches, database introspection, and executing…
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…
CloudBase Relational Database MCP Tool
An MCP tool for managing CloudBase Relational Databases, enabling agents to provision MySQL instances, execute SQL queries, and manage table-level permissions.
CloudBase Relational Database Management Tool
An MCP-compatible toolset for managing the lifecycle and data of CloudBase Relational Databases. It enables agents to provision MySQL instances, execute SQL queries, and configure table-level permissions.
Wren SQL Query Generation and Correction
This skill assists in generating and debugging SQL queries for Wren Engine, ensuring adherence to its semantic layer (MDL) and dialect quirks. It covers MDL query rules, data types, and error diagnosis, promoting efficient and accurate data…
Connect SaaS Data to Wren Engine
This skill guides users through connecting SaaS data (HubSpot, Stripe, Salesforce, GitHub, Slack, etc.) to Wren Engine for SQL analysis. It covers installation, credential setup, pipeline execution, DuckDB file creation, and Wren project ge…
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…