skills.rest
raw-labs
raw-labsOFFICIAL
Explore all skills by this author →
Website𝕏@raw_labsGitHub

mxcp-creator

Initialize MXCP projects with SQL and Python endpoints for PostgreSQL databases.

2|Updated Oct 20, 2025
One-click install
npx skills add https://github.com/raw-labs/claude-code-marketplace --skill mxcp-creator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mxcp-creator
Source: https://github.com/raw-labs/claude-code-marketplace/tree/main/.claude-plugin/plugins/mxcp-plugin/skills/mxcp-creator
Command: npx skills add https://github.com/raw-labs/claude-code-marketplace --skill mxcp-creator

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires uv, mxcp, black, pyright, pytest, pytest-asyncio, pytest-httpx, pytest-cov, dbt-core, dbt-duckdb, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill simplifies the complex process of building, configuring, and deploying enterprise-grade AI applications using the MXCP framework. It automates the setup of secure, robust, and testable AI endpoints, eliminating manual configuration and ensuring compliance with best practices. This allows developers to focus on business logic rather than infrastructure, accelerating time-to-production for AI solutions.

Core Features & Use Cases

  • Guided MXCP Project Creation: Initialize and structure production-ready MCP servers with SQL and Python endpoints, complete with security, audit trails, and policy enforcement.
  • Automated Enterprise Features: Implement authentication (OAuth, SSO), policy enforcement with CEL expressions, and comprehensive audit logging with minimal effort.
  • Comprehensive Quality Assurance: Validate, test, lint, and evaluate endpoints using mxcp CLI tools and dbt integration to ensure reliability, security, and LLM-friendly interactions before deployment.
  • Use Case: A data team needs to expose a new customer analytics dataset via an AI agent. This Skill guides them through creating an MXCP project, integrating dbt for data transformation, defining SQL endpoints, setting up OAuth authentication, and implementing access policies, all while ensuring the solution is production-ready and secure.

Quick Start

Use the mxcp-creator skill to help me initialize a new MXCP project for connecting to a PostgreSQL database.