{
"tool_response": [
{
"type": "text",
"text": "{\n \"success\": true,\n \"doc\": {\n \"id\": 70,\n \"parent_id\": 65,\n \"slug\": \"mcp-contracts-installation\",\n \"path\": \"\/mcp\/mcp-contracts\/mcp-contracts-installation\",\n \"title\": \"Installation\",\n \"description\": null,\n \"content\": \"<nav class=\\\"breadcrumb\\\">\\n <a href=\\\"\/docs\\\">Dokumentation<\/a> » <a href=\\\"\/docs\/mcp\\\">MCP<\/a> » <a href=\\\"\/docs\/mcp\/mcp-contracts\\\">MCP-Contracts<\/a> » Installation\\n<\/nav>\\n\\n<h1>MCP-Contracts Installation<\/h1>\\n<p>Setup, Konfiguration und Registrierung des MCP-Contracts Servers.<\/p>\\n\\n<h2>Voraussetzungen<\/h2>\\n<ul>\\n <li>Python 3.10+<\/li>\\n <li>MariaDB\/MySQL mit ki_protokoll Datenbank<\/li>\\n <li>Claude Code CLI<\/li>\\n<\/ul>\\n\\n<h2>Installation<\/h2>\\n\\n<h3>1. Verzeichnis erstellen<\/h3>\\n<pre><code>mkdir -p \/opt\/mcp-servers\/mcp-contracts\\ncd \/opt\/mcp-servers\/mcp-contracts<\/code><\/pre>\\n\\n<h3>2. Virtual Environment<\/h3>\\n<pre><code>python3 -m venv venv\\nsource venv\/bin\/activate\\npip install mcp pymysql python-dotenv pyyaml<\/code><\/pre>\\n\\n<h3>3. Environment-Datei<\/h3>\\n<pre><code># .env\\nDB_HOST=localhost\\nDB_PORT=3306\\nDB_NAME=ki_protokoll\\nDB_USER=claude_code\\nDB_PASSWORD=geheim\\n\\nLOG_DB_HOST=localhost\\nLOG_DB_NAME=ki_protokoll\\nLOG_DB_USER=mcp_logger\\nLOG_DB_PASSWORD=geheim<\/code><\/pre>\\n\\n<h3>4. Datenbank-Tabellen<\/h3>\\n<pre><code>-- In ki_protokoll ausführen\\nCREATE TABLE IF NOT EXISTS contracts (\\n id INT AUTO_INCREMENT PRIMARY KEY,\\n name VARCHAR(255) NOT NULL,\\n yaml_content TEXT NOT NULL,\\n version VARCHAR(50) DEFAULT '1.0',\\n status ENUM('draft','active','deprecated') DEFAULT 'active',\\n scope_description TEXT,\\n created_by VARCHAR(100),\\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n UNIQUE KEY (name, version)\\n);\\n\\nCREATE TABLE IF NOT EXISTS contract_history (\\n id INT AUTO_INCREMENT PRIMARY KEY,\\n contract_id INT NOT NULL,\\n old_version VARCHAR(50),\\n new_version VARCHAR(50),\\n old_yaml_content TEXT,\\n change_description TEXT,\\n changed_by VARCHAR(100),\\n changed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\\n FOREIGN KEY (contract_id) REFERENCES contracts(id)\\n);\\n\\nCREATE TABLE IF NOT EXISTS contract_validations (\\n id INT AUTO_INCREMENT PRIMARY KEY,\\n contract_id INT NOT NULL,\\n passed BOOLEAN DEFAULT FALSE,\\n violations_count INT DEFAULT 0,\\n violations_json TEXT,\\n triggered_by VARCHAR(50),\\n validated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\\n FOREIGN KEY (contract_id) REFERENCES contracts(id)\\n);<\/code><\/pre>\\n\\n<h2>Registrierung in Claude Code<\/h2>\\n<pre><code># MCP-Server registrieren\\nclaude mcp add mcp-contracts \\\\\\n --transport stdio \\\\\\n -- \/opt\/mcp-servers\/mcp-contracts\/venv\/bin\/python \\\\\\n \/opt\/mcp-servers\/mcp-contracts\/server.py\\n\\n# Registrierung prüfen\\nclaude mcp list<\/code><\/pre>\\n\\n<h2>Test<\/h2>\\n<pre><code># In Claude Code Session\\ncontracts_list(compact=True)\\ncontracts_statistics()<\/code><\/pre>\\n\\n<h2>Fehlerbehebung<\/h2>\\n\\n<h3>Server startet nicht<\/h3>\\n<pre><code># Manuell testen\\n\/opt\/mcp-servers\/mcp-contracts\/venv\/bin\/python \\\\\\n \/opt\/mcp-servers\/mcp-contracts\/server.py\\n\\n# Logs prüfen\\ntail -f ~\/.claude\/logs\/mcp-*.log<\/code><\/pre>\\n\\n<h3>Datenbankverbindung fehlgeschlagen<\/h3>\\n<ul>\\n <li>.env Credentials prüfen<\/li>\\n <li>DB-User Berechtigungen prüfen<\/li>\\n <li>MariaDB-Service Status: <code>systemctl status mariadb<\/code><\/li>\\n<\/ul>\\n\\n<h3>Tool nicht gefunden<\/h3>\\n<pre><code># MCP-Server neu registrieren\\nclaude mcp remove mcp-contracts\\nclaude mcp add mcp-contracts ...<\/code><\/pre>\\n\\n<h2>Berechtigungen<\/h2>\\n<table>\\n <tr><th>DB-User<\/th><th>Datenbank<\/th><th>Rechte<\/th><\/tr>\\n <tr><td><code>claude_code<\/code><\/td><td>ki_protokoll<\/td><td>SELECT, INSERT, UPDATE, DELETE auf contracts*<\/td><\/tr>\\n <tr><td><code>mcp_logger<\/code><\/td><td>ki_protokoll<\/td><td>INSERT auf mcp_log<\/td><\/tr>\\n<\/table>\",\n \"status\": \"published\",\n \"sort_order\": 3,\n \"depth\": 2,\n \"created_at\": \"2025-12-20T13:01:58\",\n \"updated_at\": \"2025-12-20T13:01:58\"\n }\n}"
}
]
}