Joel Masci

Reports on the size and structure of your database. Shows where your data is distributed among your database tables.
Note: This plugin is somewhat geared towards developers.
See the FAQ for more info.
Some screenshots can be found here for the time being: https://github.com/j-masci/wp-db-analyzer
<h3>Contributors & Developers</h3>
Feel free to suggest or add anything that you might find useful:
https://github.com/j-masci/wp-db-analyzer

Database Analyzer

Reports on the size and structure of your database. Shows where your data is distributed among your database tables.

Timon

The SlyMetrics WordPress plugin is a powerful monitoring plugin that exports comprehensive WordPress metrics in Prometheus format. Perfect for DevOps teams and system administrators who want to monitor their WordPress sites using modern observability tools.
Key Features:
<ul>
<li>Prometheus Naming Compliance – All metrics follow Prometheus best practices with consistent naming</li>
<li>Secure Authentication – Multiple authentication methods with encrypted token storage and rate limiting</li>
<li>Comprehensive Metrics – WordPress users, posts, pages, plugins, themes, comments, categories, tags, and media</li>
<li>Advanced Monitoring – WordPress version tracking, autoload performance, PHP configuration, database size</li>
<li>Site Health Integration – WordPress Site Health API integration for security and performance monitoring</li>
<li>Directory Size Monitoring – Track uploads, themes, and plugins directory sizes with intelligent caching</li>
<li>REST API Integration – Uses native WordPress REST API with enhanced security</li>
<li>Performance Optimization – 3-tier caching system with lazy loading and memory optimization</li>
<li>Enterprise Security – Input validation, SQL injection prevention, XSS protection, and security headers</li>
<li>Environment Variable Support – Enhanced security with external encryption key management</li>
<li>Admin Interface – User-friendly settings page with token management</li>
<li>Multi-Site Support – All metrics include site labels for multi-site filtering</li>
<li>Grafana Optimized – Display-friendly metrics specifically designed for clean table visualizations</li>
<li>Clean URL Support – WordPress Rewrite API integration for /slybase/metrics endpoints</li>
<li>Professional Code Quality – Enterprise-grade architecture with comprehensive error handling</li>
</ul>
Available Metrics:
<ul>
<li>User counts per role</li>
<li>Post and page statistics by status</li>
<li>Plugin and theme information</li>
<li>Comment statistics</li>
<li>WordPress version and update status</li>
<li>Database and directory sizes</li>
<li>PHP configuration details</li>
<li>Site health check results</li>
<li>Grafana-optimized display metrics for clean table visualizations</li>
<li>Individual health check test results with detailed descriptions</li>
<li>And much more…</li>
</ul>
Authentication Methods:
<ol>
<li>Bearer Token (Recommended)</li>
<li>API Key (URL Parameter)</li>
<li>WordPress Administrator (Automatic access for logged-in admins)</li>
</ol>
Security Features:
<ul>
<li>AES-256-CBC encryption for token storage</li>
<li>Environment variable support for encryption keys</li>
<li>Secure random token generation</li>
<li>Multiple fallback authentication methods</li>
<li>Enterprise-grade input validation and sanitization</li>
<li>Advanced SQL injection prevention</li>
<li>XSS and CSRF protection with security headers</li>
<li>Rate limiting with IP-based throttling</li>
<li>Enhanced client IP detection with proxy support</li>
</ul>
Performance Features:
<ul>
<li>3-tier intelligent caching strategy</li>
<li>Lazy loading for heavy operations</li>
<li>Memory-optimized data structures</li>
<li>Database query optimization</li>
<li>Segmented cache invalidation</li>
<li>Background processing for directory scans</li>
</ul>
<h3>Additional Information</h3>
GitHub Repository: https://github.com/slydlake/slymetrics
Grafana Dashboard: Included in the plugin package for comprehensive WordPress monitoring.
Support: For issues and feature requests, please visit the GitHub repository.
Security: For enhanced security in production, use environment variables for encryption keys and implement network-level access controls. Version 1.2.0 includes enterprise-grade security features including rate limiting, input validation, and comprehensive protection against common web vulnerabilities.

SlyMetrics

A comprehensive WordPress plugin that exports WordPress metrics in Prometheus format for monitoring and observability.

Database Analyzer vs SlyMetrics