Agent skill · software engineering · aiskillstore
mcp-server
Generic MCP (Model Context Protocol) server development patterns. Provides reusable architecture and best practices for building MCP servers that expose any domain-specific operations as tools for AI agents. Framework-agnostic implementation supporting async operations, error handling, and enterprise-grade features.
Why this skill is useful
Adds a complete architecture for building MCP servers with reusable patterns and enterprise features, which the AI cannot generate on its own.
What it needs
Requires redis installed locally. About 7k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
Generic MCP Server Development This skill provides comprehensive patterns and reusable code for building MCP (Model Context Protocol) servers that can expose any domain operations as tools for AI agents. Follows 2025 best practices for performance, security, and maintainability. When to Use This Skill Use this skill when you need to: Build an MCP server for any domain (not just todos) Expose database operations as MCP tools Create AI-agent accessible APIs Implement async MCP tool handlers Add proper error handling and validation Support rate limiting and caching Build enterprise-grade MCP servers Integrate with multiple storage backends 1. Generic MCP Server Architecture 2. Database Integration Patterns `python mcpserver/database.py """ Generic Database Integration for MCP Servers Supports multiple ORMs and connection patterns """ import asyncio from abc import ABC, abstractmethod from contextlib import asynccontextmanager from typing import Any, Dict, List, Optional, TypeVar, Generic, Union from datetime import datetime import json from sqlalchemy import createengine, MetaData, Table, Column, Integer, String, DateTime, Text, Boolean, select, update, delete, insert from sqlalchemy.ext.asyncio import createasyncengine, AsyncSession, asyncsessionmaker from sqlalchemy.orm import sessionmaker, declarativebase from sqlalchemy.pool import NullPool import asyncpg import motor.motorasyncio from redis.asyncio import Redis Type variables T = TypeVar('T') class DatabaseBackend(ABC): """Abstract base for database backends""" @abstractmethod async def connect(self): """Establish connection""" pass @abstractmethod async def disconnect(self): """Close connection""" pass @abstractmethod async def executequery(self, query: str, params: Dict[str, Any] = None) -> List[Dict[str, Any]]: """Execute a query and return results""" pass @abstractmethod async def executecommand(self, command: str, params: Dict[str, Any] = None) -> Any: """Execute a command (INSERT, UPDATE, DELETE)""" pass cla …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/mcp-server