{"_id":"@arthurfranckpat/sage-x3-mcp","_rev":"3-cdd7b68637f200f11a236ecca2e0cecc","name":"@arthurfranckpat/sage-x3-mcp","dist-tags":{"latest":"1.2.0"},"versions":{"1.0.0":{"name":"@arthurfranckpat/sage-x3-mcp","version":"1.0.0","keywords":["mcp","sage-x3","erp","model-context-protocol","claude","llm"],"author":{"name":"Arthur"},"license":"MIT","_id":"@arthurfranckpat/sage-x3-mcp@1.0.0","maintainers":[{"name":"arthurfranckpat","email":"arthur.bledou@gmail.com"}],"homepage":"https://github.com/arthurfranckpat/sage-x3-mcp#readme","bugs":{"url":"https://github.com/arthurfranckpat/sage-x3-mcp/issues"},"bin":{"sage-x3-mcp":"bin/sage-x3-mcp.js"},"dist":{"shasum":"69ee7024bdf66e6ecc8ff5d32c535fb9f6418cdf","tarball":"https://registry.npmjs.org/@arthurfranckpat/sage-x3-mcp/-/sage-x3-mcp-1.0.0.tgz","fileCount":16,"integrity":"sha512-Dy0AF8yjLhixvafPrQAHBDEZCr+EOxNZuzguA3R4mATw2cSnUpUmo4SNb+vzqAHKQeiGxWO2OSsMxaGAg4prxg==","signatures":[{"sig":"MEUCIQDJA0ruDv1V/LwJK4FuqSnjeVDRKLo1+1PvvB7ZA+ngugIgRU78lnfXp7IU6Ef9mE3QfnwRhWznSREHcQVc4scPw3o=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":52995},"main":"bin/sage-x3-mcp.js","engines":{"node":">=16.0.0"},"gitHead":"129523e56b1396ef5baf05b5c566b8e5368ffe78","scripts":{"test":"python3 test_server.py","serve":"node bin/sage-x3-mcp.js server","start":"node bin/sage-x3-mcp.js"},"_npmUser":{"name":"arthurfranckpat","email":"arthur.bledou@gmail.com"},"repository":{"url":"git+https://github.com/arthurfranckpat/sage-x3-mcp.git","type":"git"},"_npmVersion":"11.5.2","description":"MCP Server pour base de connaissance Sage X3 - Accès aux tables, champs et menus locaux","directories":{},"_nodeVersion":"22.17.0","dependencies":{},"_hasShrinkwrap":false,"devDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/sage-x3-mcp_1.0.0_1759573321682_0.9330387273017486","host":"s3://npm-registry-packages-npm-production"}},"1.1.0":{"name":"@arthurfranckpat/sage-x3-mcp","version":"1.1.0","keywords":["mcp","sage-x3","erp","model-context-protocol","claude","llm"],"author":{"name":"Arthur Franck-Pat"},"license":"MIT","_id":"@arthurfranckpat/sage-x3-mcp@1.1.0","maintainers":[{"name":"arthurfranckpat","email":"arthur.bledou@gmail.com"}],"homepage":"https://github.com/arthurfranckpat/sage-x3-mcp#readme","bugs":{"url":"https://github.com/arthurfranckpat/sage-x3-mcp/issues"},"bin":{"sage-x3-mcp":"bin/sage-x3-mcp.js"},"dist":{"shasum":"36d1bb2cc94af284086fb5a85b6eb637766deaec","tarball":"https://registry.npmjs.org/@arthurfranckpat/sage-x3-mcp/-/sage-x3-mcp-1.1.0.tgz","fileCount":16,"integrity":"sha512-L8oVEWZajSPsWCheKWk3PYoMdeZa8y2GlIxUCp+mkGecdnPHjjq+nlwXWPBrT/tR2doxixemfA1pXb8NormsUg==","signatures":[{"sig":"MEYCIQC/HCexbmf/3zY8aFg/dkRzWJjYWN+QmX+CyW9HIwCmWgIhAMfFuZAHrsn7h1aGGH1e28t0JE2q+RbfCDaWjgaAQ5HW","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":53128},"main":"bin/sage-x3-mcp.js","engines":{"node":">=16.0.0"},"gitHead":"129523e56b1396ef5baf05b5c566b8e5368ffe78","scripts":{"test":"python3 test_server.py","serve":"node bin/sage-x3-mcp.js server","start":"node bin/sage-x3-mcp.js"},"_npmUser":{"name":"arthurfranckpat","email":"arthur.bledou@gmail.com"},"repository":{"url":"git+https://github.com/arthurfranckpat/sage-x3-mcp.git","type":"git"},"_npmVersion":"11.5.2","description":"MCP Server pour base de connaissance Sage X3 - Accès aux tables, champs et menus locaux","directories":{},"_nodeVersion":"22.17.0","dependencies":{},"_hasShrinkwrap":false,"devDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/sage-x3-mcp_1.1.0_1759575591171_0.10311411444265972","host":"s3://npm-registry-packages-npm-production"}},"1.2.0":{"name":"@arthurfranckpat/sage-x3-mcp","version":"1.2.0","description":"MCP Server pour base de connaissance Sage X3 - Accès aux tables, champs et menus locaux","main":"bin/sage-x3-mcp.js","bin":{"sage-x3-mcp":"bin/sage-x3-mcp.js"},"scripts":{"start":"node bin/sage-x3-mcp.js","serve":"node bin/sage-x3-mcp.js server","test":"python3 test_server.py","update":"node bin/sage-x3-mcp.js --update"},"keywords":["mcp","sage-x3","erp","model-context-protocol","claude","llm"],"author":{"name":"Arthur Franck-Pat"},"license":"MIT","repository":{"type":"git","url":"git+https://github.com/arthurfranckpat/sage-x3-mcp.git"},"engines":{"node":">=16.0.0"},"dependencies":{},"devDependencies":{},"_id":"@arthurfranckpat/sage-x3-mcp@1.2.0","gitHead":"6bae608496a1ac45ad9b87fc6fa761f354e3a240","bugs":{"url":"https://github.com/arthurfranckpat/sage-x3-mcp/issues"},"homepage":"https://github.com/arthurfranckpat/sage-x3-mcp#readme","_nodeVersion":"22.17.0","_npmVersion":"11.5.2","dist":{"integrity":"sha512-nj5A5Bkn6tUG/pFHvQKbXxAl5Xy3nZJPx64Oh5GQZn4bNlurJFPjIiGuRQAg50vHKajlkpeTVfx5BH/5YexeKw==","shasum":"a2feb0b70f3ea7de493738871b63b17c1396d247","tarball":"https://registry.npmjs.org/@arthurfranckpat/sage-x3-mcp/-/sage-x3-mcp-1.2.0.tgz","fileCount":16,"unpackedSize":57980,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEYCIQCMkMdAdW3VD9KxiQy5UhFSZJwOv1z8OhILghQ3GLlt0AIhAMdLoUPMvg5lQvITOnhLeH8uq0BvR3VPMOGHIlAQ6yoh"}]},"_npmUser":{"name":"arthurfranckpat","email":"arthur.bledou@gmail.com"},"directories":{},"maintainers":[{"name":"arthurfranckpat","email":"arthur.bledou@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/sage-x3-mcp_1.2.0_1759577230258_0.7636986418710558"},"_hasShrinkwrap":false}},"time":{"created":"2025-10-04T10:22:01.581Z","modified":"2025-10-04T11:27:10.638Z","1.0.0":"2025-10-04T10:22:01.924Z","1.1.0":"2025-10-04T10:59:51.401Z","1.2.0":"2025-10-04T11:27:10.456Z"},"bugs":{"url":"https://github.com/arthurfranckpat/sage-x3-mcp/issues"},"author":{"name":"Arthur Franck-Pat"},"license":"MIT","homepage":"https://github.com/arthurfranckpat/sage-x3-mcp#readme","keywords":["mcp","sage-x3","erp","model-context-protocol","claude","llm"],"repository":{"type":"git","url":"git+https://github.com/arthurfranckpat/sage-x3-mcp.git"},"description":"MCP Server pour base de connaissance Sage X3 - Accès aux tables, champs et menus locaux","maintainers":[{"name":"arthurfranckpat","email":"arthur.bledou@gmail.com"}],"readme":"# @arthurfranckpat/sage-x3-mcp\n\n> 🚀 Serveur MCP (Model Context Protocol) pour base de connaissance Sage X3\n\nPermet à Claude et autres LLM d'accéder à une base de connaissance Sage X3 complète avec 1,888 tables, 47,367 champs et 608 menus locaux.\n\n## 📦 Installation\n\n### Utilisation avec npx (recommandé)\n\n```bash\n# Mode stdio pour Claude Desktop\nnpx @arthurfranckpat/sage-x3-mcp\n\n# Mode serveur HTTP\nnpx @arthurfranckpat/sage-x3-mcp server --port 3000\n```\n\n### Installation globale\n\n```bash\nnpm install -g @arthurfranckpat/sage-x3-mcp\n\n# Puis utiliser\nsage-x3-mcp\nsage-x3-mcp server\n```\n\n## 🚀 Utilisation\n\n### Mode 1 : Stdio (Claude Desktop)\n\nPour une utilisation avec Claude Desktop en local :\n\n**Configuration `claude_desktop_config.json` :**\n\n```json\n{\n  \"mcpServers\": {\n    \"sage-x3\": {\n      \"command\": \"npx\",\n      \"args\": [\"@arthurfranckpat/sage-x3-mcp\"],\n      \"env\": {\n        \"SAGE_DATA_PATH\": \"/path/to/your/sage_x3_knowledge_base\"\n      }\n    }\n  }\n}\n```\n\n**Localisation du fichier :**\n- macOS: `~/Library/Application Support/Claude/claude_desktop_config.json`\n- Windows: `%APPDATA%\\Claude\\claude_desktop_config.json`\n\n### Mode 2 : Serveur HTTP/SSE\n\nPour un accès distant ou via un serveur web :\n\n```bash\n# Démarrer le serveur\nnpx @arthurfranckpat/sage-x3-mcp server --port 3000 --host 0.0.0.0\n\n# Ou avec données personnalisées\nnpx @arthurfranckpat/sage-x3-mcp server --data-path /path/to/data\n```\n\n**Configuration Claude Desktop (HTTP) :**\n\n```json\n{\n  \"mcpServers\": {\n    \"sage-x3\": {\n      \"url\": \"http://localhost:3000/sse\"\n    }\n  }\n}\n```\n\n**Endpoints disponibles :**\n- `GET /` - Informations serveur\n- `GET /health` - Health check\n- `GET /sse` - Server-Sent Events (MCP)\n- `GET /tools` - Liste des outils\n- `GET /resources` - Liste des ressources\n- `POST /call-tool` - Exécuter un outil\n\n## 🛠️ Outils MCP\n\n### 1. `search_tables`\nRecherche des tables par nom ou mot-clé\n\n```typescript\n{\n  \"name\": \"search_tables\",\n  \"arguments\": {\n    \"query\": \"SORDER\"\n  }\n}\n```\n\n### 2. `get_table_details`\nObtient tous les champs d'une table\n\n```typescript\n{\n  \"name\": \"get_table_details\",\n  \"arguments\": {\n    \"table_name\": \"SORDER\"\n  }\n}\n```\n\n### 3. `search_menus`\nRecherche des menus locaux (enums)\n\n```typescript\n{\n  \"name\": \"search_menus\",\n  \"arguments\": {\n    \"query\": \"statut\"\n  }\n}\n```\n\n### 4. `get_menu_values`\nObtient les valeurs d'un menu local\n\n```typescript\n{\n  \"name\": \"get_menu_values\",\n  \"arguments\": {\n    \"menu_number\": 415\n  }\n}\n```\n\n### 5. `validate_sql_conventions`\nVérifie qu'une requête SQL respecte les conventions Sage X3\n\n### 6. `get_table_relations`\nTrouve les relations d'une table avec d'autres tables\n\n## 📚 Ressources disponibles\n\n- `guide://00_GUIDE_LLM` - Guide de génération SQL\n- `guide://01_GLOSSAIRE` - Conventions Sage X3\n- `guide://03_RELATIONS` - Relations entre tables\n\n## ⚙️ Configuration\n\n### Variables d'environnement\n\n- `SAGE_DATA_PATH` : Chemin vers les données Sage X3 (requis)\n\n### Options CLI\n\n```bash\nsage-x3-mcp [mode] [options]\n\nModes:\n  stdio         Mode stdio pour Claude Desktop (défaut)\n  server        Mode serveur HTTP/SSE\n\nOptions:\n  --port        Port du serveur HTTP (défaut: 3000)\n  --host        Host du serveur (défaut: 0.0.0.0)\n  --data-path   Chemin vers les données\n  --help, -h    Affiche l'aide\n```\n\n## 📊 Données accessibles\n\n- **1,888 tables** de votre ERP Sage X3\n- **47,367 champs** avec types et descriptions\n- **608 menus locaux** avec 3,127 valeurs d'enums\n- **Guides complets** pour génération SQL\n\n## 🧪 Test\n\n```bash\n# Tester le serveur HTTP\nnpm test\n\n# Ou manuellement\ncurl http://localhost:3000/health\n```\n\n## 📖 Exemples\n\n### Rechercher des tables\n\n```bash\n# Avec curl\ncurl -X POST http://localhost:3000/call-tool \\\n  -H \"Content-Type: application/json\" \\\n  -d '{\"name\":\"search_tables\",\"arguments\":{\"query\":\"SORDER\"}}'\n```\n\n### Obtenir détails d'une table\n\n```bash\ncurl -X POST http://localhost:3000/call-tool \\\n  -H \"Content-Type: application/json\" \\\n  -d '{\"name\":\"get_table_details\",\"arguments\":{\"table_name\":\"SORDER\"}}'\n```\n\n## 🔧 Dépendances\n\n**Python :**\n- Python 3.10+\n- mcp >= 0.9.0\n- fastapi >= 0.104.0 (mode serveur)\n- uvicorn >= 0.24.0 (mode serveur)\n- sse-starlette >= 1.8.0 (mode serveur)\n\n**Node.js :**\n- Node.js 16+\n\n## 🐛 Dépannage\n\n### Erreur \"SAGE_DATA_PATH non trouvé\"\n\nAssurez-vous de définir la variable d'environnement :\n\n```bash\nexport SAGE_DATA_PATH=/chemin/vers/sage_x3_knowledge_base\n```\n\n### Erreur \"Python dependencies not installed\"\n\n```bash\ncd node_modules/@arthurfranckpat/sage-x3-mcp\npip install -r requirements.txt\n```\n\n### Le serveur ne démarre pas\n\nVérifiez que Python 3 est installé :\n\n```bash\npython3 --version\n```\n\n## 📄 License\n\nMIT\n\n## 🔗 Liens\n\n- [Documentation complète](https://github.com/arthurfranckpat/sage-x3-mcp)\n- [Model Context Protocol](https://modelcontextprotocol.io)\n- [Issues](https://github.com/arthurfranckpat/sage-x3-mcp/issues)\n\n## 👤 Auteur\n\nArthur Franck-Pat\n\n---\n\n**Note :** Ce package nécessite des données Sage X3 pour fonctionner. Consultez la documentation pour créer votre base de connaissance.\n","readmeFilename":"README.npm.md"}