Why We Built EverNext Reporting

The Problem

WordPress powers over 40% of the web. You'd think reporting would be a solved problem by now. It's not. Not even close.

Most WordPress reporting plugins only care about WooCommerce data or basic site stats — page views, form submissions, maybe some user counts. That's fine if you're running a blog. But real businesses? They have data everywhere. External MySQL databases running their CRM. PostgreSQL powering their inventory system. Custom applications with their own data stores. ERPs, order management systems, customer portals — all living in databases that WordPress plugins completely ignore.

So what do these businesses do? They export CSVs. They build Excel reports manually. Every Monday morning, someone on the team spends two hours pulling data from three different systems, copying it into a spreadsheet, formatting it to look presentable, and emailing it to the people who need it. Then on Tuesday, someone asks for the same data sliced a different way, and the whole process starts over.

We saw this pattern repeatedly — businesses running WordPress as their primary platform but forced to use completely separate BI tools (or nothing at all) for their actual reporting needs. The enterprise tools exist. Tableau, Power BI, Looker — they're powerful. They're also expensive, complex, and require dedicated analysts to operate. A 50-person company doesn't need a $70,000/year BI platform. They need something that works where their team already lives.

What We Built

EverNext Reporting connects to any MySQL, MariaDB, or PostgreSQL database and brings full reporting capabilities directly inside WordPress. Your team already logs into WordPress every day — to manage content, check orders, update pages. Why make them learn another tool just to see their data?

We designed it so that anyone on your team can build a report without writing a single line of code. But we also made sure power users get a full SQL editor, because sometimes you just need to write the query yourself. Both paths are first-class citizens.

Visual Query Builder

The visual query builder is a point-and-click interface for building database queries. Select your tables, pick your columns, add filters and sorting — all without touching SQL. The WHERE clause builder is powered by jQuery QueryBuilder, which gives you multiple operators (equals, contains, greater than, between, is null, and more) with a clean UI that anyone can understand.

No SQL knowledge needed. Your operations manager, your account reps, your support lead — anyone on the team can build the reports they need without filing a ticket with IT.

For power users, there's a full SQL editor with syntax highlighting. Write whatever query you want. And before you ask — yes, security is built in. Dangerous SQL keywords like DROP, DELETE, ALTER, and TRUNCATE are blocked automatically. Your database stays safe even when giving team members direct query access.

14 Visualization Types

We didn't stop at bar charts and pie charts. Different data tells different stories, and you need the right visualization to tell each one. We built 14 chart types:

• Bar, Line, Pie, Doughnut, Polar Area, Radar — the fundamentals that cover most use cases
• Stacked Bar, Horizontal Bar, Stacked Area — for part-to-whole comparisons and categorical breakdowns
• Combo Chart — mixed bar and line on one chart, perfect for showing volume alongside trends
• Scatter Plot — for spotting correlations in your data
• Gauge — for showing progress within a target range
• KPI Cards — single big-number metrics that tell you what matters at a glance
• Data Tables — searchable, sortable, with conditional formatting and one-click export

Every chart is configurable. Choose from 7 built-in color palettes, enable multi-series support, apply aggregation functions (sum, average, count, min, max), and set custom labels. You get the chart you actually want, not a generic default.

Multi-Source Data Joins

This is the feature we're most excited about, and honestly, it's the one that made us realize this plugin needed to exist.

You can connect data from two completely different databases and join them in a single report. Inner joins, left joins, right joins — pick the join type that fits your use case. Want to join your CRM database with your inventory database to see which customers ordered out-of-stock items? Done. Want to combine your support ticket system with your billing database to see revenue by ticket volume? You can do that.

No other WordPress reporting plugin does this. You can preview each data source separately to make sure you're pulling the right data, then preview the merged result before saving. No guesswork, no surprises.

Calculated Fields

Sometimes the number you need isn't in your database — it's derived from other numbers. Calculated fields let you create virtual columns using math formulas. Use your column names as variables: revenue - cost, quantity * unit_price, (total_sales / num_orders). The calculations happen on the fly when the report runs. No need to modify your database schema or create views just to get a profit margin column.

Dashboards

Individual reports are useful. Dashboards that combine multiple reports on one screen are where things get powerful.

The dashboard builder uses a drag-and-drop 12-column responsive grid. Add reports as widgets, resize them, reorder them, and adjust grid gaps until everything looks right. Add global filters that broadcast to every report on the dashboard — select a date range once and every chart updates. Embed any dashboard anywhere on your site with shortcodes.

Automated Email Reports

Remember that person spending Monday morning pulling data and emailing spreadsheets? That's automated now.

Schedule any report or dashboard to be emailed automatically — hourly, daily, weekly, or monthly. Add multiple recipients. Every email includes an Excel file attachment with the full dataset. Customize the subject line and message body. Pause and resume schedules whenever you need to. And you can send a test email before going live to make sure everything looks right.

Drill-Down Navigation

Click a bar in a chart and drill into the detail behind it. Configure which report to navigate to when a user clicks, and filters pass automatically so the detail report is already scoped to the right data. A breadcrumb trail shows where you are in the drill-down path, and one click takes you back up. It turns static charts into interactive data exploration tools.

Report Parameters & Dynamic Filters

Add dropdown filters, date range pickers, and text inputs to any report. Users filter their own data without ever touching the underlying query. Parameters work in shortcodes and via URL — which makes them perfect for building data portals where different users see different slices of the same report. Date parameters auto-normalize across formats so you don't have to worry about whether someone picked "2026-04-12" or "04/12/2026."

Access Control & Security

We took security seriously from day one. Every report can be set to public, logged-in only, or role-based visibility. Database connection passwords are encrypted with AES-256-CBC. All queries use PDO prepared statements to prevent SQL injection. WordPress nonces protect against CSRF attacks. And the REST API supports API key authentication so you control exactly who has programmatic access.

REST API

For developers who want to integrate report data into other systems, there's a full REST API. List reports, fetch data, refresh cache — it's all there. Authenticate with an API key or WordPress application passwords. Responses come back as clean JSON with the full report data and configuration.

Export Everything

Every data table includes one-click export to CSV, Excel, and PDF. Exports include the full dataset, not just the visible page. The same export formats show up as attachments in scheduled emails. Your data, your way, whenever you need it.

Built-in Templates

Nobody wants to start from a blank screen. We included 15 pre-configured templates — bar charts, line charts, KPI cards, data tables, gauges, and more. Start from a template and customize it, or build from scratch if you prefer. You can also save your own reports as custom templates for your team to reuse.

Auto-Refresh

For real-time dashboards, auto-refresh keeps your data current with configurable intervals from 10 seconds to 1 hour. It's AJAX-based, so the page never reloads — just the data updates. A visual indicator shows when a refresh is happening. Perfect for wall-mounted dashboards in your warehouse, operations screens in your office, or any situation where you need live data without someone hitting F5 every few minutes.

Theming & Customization

EverNext Reporting supports light and dark mode, custom primary colors, font family selection (System UI, Inter, Roboto, Georgia), and fine-grained controls for border radius and shadows. Need more control? Add custom CSS using CSS variables. Data tables support conditional formatting — set color rules based on cell values so important numbers stand out automatically.

What's Next

We're actively building and refining multi-source joins to combine data from different databases into single reports — it's the feature that keeps surprising us with new use cases every week.

A free version is coming to WordPress.org with core features — MySQL and MariaDB connections, the visual query builder, essential chart types, and basic dashboards. The Pro version adds PostgreSQL support, email scheduling, advanced chart types, multi-source joins, and priority support.

Check out the product page to see everything in detail, or sign up for notifications so you know the moment it launches.