SQL query → WordPress table
in minutes, no coding
You have a database table and want to show it on a WordPress page — with pagination, filtering, and sorting. Most table plugins can’t do this. Here’s the one that can.
The Problem with Most Table Plugins
TablePress, Ninja Tables, and similar plugins store their own data — not yours.
To display your data, you’d export it to CSV, import it into the plugin, and repeat every time the data changes. That’s not a solution — that’s extra work forever.
Some plugins offer a “data source” feature but require database views, REST endpoints, or paid plans. What you actually want is: paste a SQL SELECT statement, get a paginated table. Done.
Set Up in Five Steps
From install to live table — no PHP required.
Install the Plugin
Search NMR jsGrid in WordPress admin → Plugins → Add New, or download from WordPress.org.
Create a New Grid
Go to NMR jsGrid → Add New Grid in the admin sidebar. Give it a name — this becomes the shortcode ID.
Select “SQL” as Data Source
Choose SQL in the Data Source section, then enter your SELECT query. The plugin runs it server-side — only the current page of results reaches the browser.
SELECT order_id, customer_name, product, quantity, order_date
FROM wp_custom_orders
WHERE status = 'active'
ORDER BY order_date DESCConfigure Columns
Add a column entry for each field in your SELECT. Choose the type (text, number, date, checkbox). Set which columns are filterable and sortable.
Embed with Shortcode
Add the shortcode to any page or post:
The grid renders with AJAX pagination, column filters, and sorting.
What You Get
Server-side everything. Your data stays in your database.
Server-side pagination
Works with tables of any size. Only the current page of results is sent to the browser.
Column filtering
Filter inputs above each column. Results update via AJAX — no page reload.
Column sorting
Click any header to sort ascending or descending. Sorting runs on the database, not in the browser.
Data not exposed in HTML
Your full dataset never appears in page source. Fetched on demand, page by page.
Any MySQL table
WordPress tables, custom plugin tables, legacy data — if WordPress can connect to it, the grid can query it.
JOINs and complex queries
The plugin runs whatever SELECT you provide. No restrictions on query complexity.
Optional: Add Editing
Enable Editing in the grid settings and specify a write table. The display grid becomes a full CRUD interface — INSERT, UPDATE, DELETE — all from the frontend, no admin access required.
Limitations
Worth knowing before you install.
Free version: 10 grids
Up to 10 grids on the free version. Pro removes the limit.
DB user permissions apply
Queries run with the WordPress database user. Use SELECT only for read-only grids.
Column auto-detection: Pro only
Free version requires manual column setup. Pro detects columns from the query automatically.
Ready to put your data on the page?
Start free. Upgrade when you need more than 10 grids or want auto column detection. One-time payment, no subscription.