get_prestashop_stats
Retrieve statistics about indexed PrestaShop documentation, including document counts, types, categories, and specialized data for development reference.
Instructions
Get statistics about indexed PrestaShop documentation.
Returns: Statistics about documents, types, categories, and specialized data
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Implementation Reference
- prestashop_mcp/server.py:322-350 (handler)The MCP tool handler for 'get_prestashop_stats', decorated with @mcp.tool() for registration. It invokes the helper get_stats() and formats the statistics into a markdown report.@mcp.tool() def get_prestashop_stats() -> str: """Get statistics about indexed PrestaShop documentation. Returns: Statistics about documents, types, categories, and specialized data """ logger.info("Getting documentation statistics") stats = get_stats() output = ["# PrestaShop Documentation Statistics\n"] output.append(f"**Total Documents:** {stats['total_documents']}\n") output.append("## By Document Type\n") for doc_type, count in sorted(stats['by_type'].items(), key=lambda x: x[1], reverse=True): output.append(f"- {doc_type}: {count}") output.append("") output.append("## By Category\n") for category, count in sorted(stats['by_category'].items(), key=lambda x: x[1], reverse=True): output.append(f"- {category}: {count}") output.append("") output.append("## Specialized Data\n") output.append(f"- Domain References (CQRS): {stats['domain_references']}") output.append(f"- UI Components: {stats['components']}") return "\n".join(output)
- prestashop_mcp/search_v2.py:207-256 (helper)Helper function that queries the SQLite database to compute statistics on indexed PrestaShop documentation, including counts by type, category, and specialized tables.def get_stats() -> Dict: """Get documentation statistics. Returns: Statistics about indexed documentation """ conn = sqlite3.connect(DB_PATH) cursor = conn.cursor() try: # Total documents cursor.execute("SELECT COUNT(*) FROM prestashop_docs") total_docs = cursor.fetchone()[0] # By document type cursor.execute(""" SELECT doc_type, COUNT(*) as count FROM prestashop_docs GROUP BY doc_type ORDER BY count DESC """) by_type = {row[0]: row[1] for row in cursor.fetchall()} # By category cursor.execute(""" SELECT category, COUNT(*) as count FROM prestashop_docs GROUP BY category ORDER BY count DESC """) by_category = {row[0]: row[1] for row in cursor.fetchall()} # Domain references cursor.execute("SELECT COUNT(*) FROM domain_references") domain_refs = cursor.fetchone()[0] # Components cursor.execute("SELECT COUNT(*) FROM components") components = cursor.fetchone()[0] return { "total_documents": total_docs, "by_type": by_type, "by_category": by_category, "domain_references": domain_refs, "components": components } finally: conn.close()