dbt CLI MCP Server

# MCP Reference Guide ## Overview This guide provides additional resources and references for Model Context Protocol (MCP) server development. It includes links to official documentation, helpful tools, and related resources. ## Official MCP Documentation - [MCP Documentation](https://modelcontextprotocol.ai) - Official documentation for the Model Context Protocol - [MCP Python SDK GitHub](https://github.com/anthropics/mcp/tree/main/python) - Python implementation of the MCP SDK - [MCP Specification](https://modelcontextprotocol.ai/specification) - Official MCP specification ## Python Libraries Documentation ### Core Libraries | Library | Documentation | Purpose | |---------|--------------|---------| | MCP Python SDK | [Documentation](https://github.com/anthropics/mcp/tree/main/python) | MCP implementation for Python | | Pydantic | [Documentation](https://docs.pydantic.dev/) | Data validation and settings management | | Argparse | [Documentation](https://docs.python.org/3/library/argparse.html) | Command-line argument parsing | | uv | [Documentation](https://github.com/astral-sh/uv) | Fast Python package installer and environment manager | ### HTTP and Networking | Library | Documentation | Purpose | |---------|--------------|---------| | Requests | [Documentation](https://requests.readthedocs.io/) | Simple HTTP client | | AIOHTTP | [Documentation](https://docs.aiohttp.org/) | Asynchronous HTTP client/server | | HTTPX | [Documentation](https://www.python-httpx.org/) | Modern HTTP client with sync and async support | ### Data Processing | Library | Documentation | Purpose | |---------|--------------|---------| | BeautifulSoup4 | [Documentation](https://www.crummy.com/software/BeautifulSoup/bs4/doc/) | HTML parsing | | LXML | [Documentation](https://lxml.de/) | XML and HTML processing | | Markdownify | [Documentation](https://github.com/matthewwithanm/python-markdownify) | Convert HTML to Markdown | ### Testing | Library | Documentation | Purpose | |---------|--------------|---------| | Pytest | [Documentation](https://docs.pytest.org/) | Testing framework | | Requests-mock | [Documentation](https://requests-mock.readthedocs.io/) | Mock HTTP requests | | Coverage.py | [Documentation](https://coverage.readthedocs.io/) | Code coverage measurement | ### Utilities | Library | Documentation | Purpose | |---------|--------------|---------| | Python-dotenv | [Documentation](https://github.com/theskumar/python-dotenv) | Environment variable management | | Validators | [Documentation](https://github.com/python-validators/validators) | Input validation utilities | ## API Integration Resources When integrating with external APIs, these resources may be helpful: ### API Documentation Standards - [OpenAPI Specification](https://spec.openapis.org/oas/latest.html) - Standard for API documentation - [JSON Schema](https://json-schema.org/) - Schema for JSON data validation ### API Testing Tools - [Postman](https://www.postman.com/) - API development and testing platform - [CURL](https://curl.se/docs/manpage.html) - Command-line tool for testing HTTP requests - [HTTPie](https://httpie.io/) - User-friendly command-line HTTP client ## Development Tools ### Python Development - [Visual Studio Code](https://code.visualstudio.com/docs/languages/python) - Popular Python editor - [PyCharm](https://www.jetbrains.com/pycharm/) - Python IDE ### Code Quality Tools - [Black](https://black.readthedocs.io/) - Python code formatter - [isort](https://pycqa.github.io/isort/) - Import sorter - [mypy](https://mypy.readthedocs.io/) - Static type checker - [flake8](https://flake8.pycqa.org/) - Linter ### Documentation Tools - [Sphinx](https://www.sphinx-doc.org/) - Documentation generator - [mkdocs](https://www.mkdocs.org/) - Project documentation ## Python Best Practices ### Python Style Guides - [PEP 8](https://peps.python.org/pep-0008/) - Style Guide for Python Code - [Google Python Style Guide](https://google.github.io/styleguide/pyguide.html) ### Type Annotations - [PEP 484](https://peps.python.org/pep-0484/) - Type Hints - [Typing Documentation](https://docs.python.org/3/library/typing.html) ### Async Programming - [Asyncio Documentation](https://docs.python.org/3/library/asyncio.html) - [Async/Await Tutorial](https://realpython.com/async-io-python/) ## Common External APIs When developing MCP servers, these popular APIs might be integrated: ### General APIs - [OpenAI API](https://platform.openai.com/docs/api-reference) - AI/LLM services - [Anthropic API](https://docs.anthropic.com/claude/reference) - Claude AI API - [OpenWeather API](https://openweathermap.org/api) - Weather data - [NewsAPI](https://newsapi.org/docs) - News articles and headlines ### Development APIs - [GitHub API](https://docs.github.com/en/rest) - GitHub development platform - [GitLab API](https://docs.gitlab.com/ee/api/) - GitLab development platform - [StackExchange API](https://api.stackexchange.com/docs) - Stack Overflow and related sites ### Data APIs - [Alpha Vantage](https://www.alphavantage.co/documentation/) - Financial data - [CoinGecko API](https://www.coingecko.com/en/api/documentation) - Cryptocurrency data - [The Movie Database API](https://developers.themoviedb.org/3/getting-started/introduction) - Movie and TV data ## Debugging and Troubleshooting ### Python Debugging - [pdb Documentation](https://docs.python.org/3/library/pdb.html) - Python debugger - [VS Code Debugging](https://code.visualstudio.com/docs/python/debugging) - Debugging Python in VS Code ### Common Issues and Solutions - [Common Python Error Types](https://docs.python.org/3/library/exceptions.html) - [Troubleshooting HTTP Requests](https://requests.readthedocs.io/en/latest/user/quickstart/#errors-and-exceptions) ## Security Resources When developing MCP servers that interact with external services, consider these security resources: - [OWASP API Security Top 10](https://owasp.org/API-Security/editions/2023/en/0x00-introduction/) - API security risks - [Python Security Best Practices](https://snyk.io/blog/python-security-best-practices-cheat-sheet/) - Security practices for Python - [Secrets Management](https://12factor.net/config) - The Twelve-Factor App methodology for config ## MCP Server Deployment ### Deployment Options - [Running as a service](https://docs.python.org/3/library/sys.html#sys.executable) - Starting the MCP server as a service - [Docker deployment](https://docs.docker.com/language/python/build-images/) - Containerizing your MCP server ### Environment Management - [Environment Variables](https://12factor.net/config) - Managing configuration in environment variables - [Dotenv Files](https://github.com/theskumar/python-dotenv) - Managing environment variables in development ## Related Concepts - [OpenAPI/Swagger](https://swagger.io/specification/) - API description format - [gRPC](https://grpc.io/docs/languages/python/basics/) - High-performance RPC framework - [Webhook Design](https://zapier.com/engineering/webhook-design/) - Best practices for webhook design ## Next Steps After reviewing these resources, you may want to: 1. Visit the [MCP Documentation](https://modelcontextprotocol.ai) for the latest updates 2. Explore the [Implementation Guide](implementation_guide.md) for practical examples 3. Check the [Testing Guide](testing_guide.md) for testing requirements