
The plugin can create beautiful charts based on your SQL queries, then you can use those charts in any part of your website.
You can use both native wp and non-wp mysql tables in your queries.
Give any name to your report.
Use our preinstalled chart or create new one yourself: choose desired chart type, type sql query,
enter field names, labels and then press to Publish/Update
You can use multiple SQL queries too. Just split them by ; sign. You can also add shortcode argument to SQL query. For example if you
type “select * from wp_posts where ID>{arg1}” then it you can pass arg1 value to the query with [gvn_schart_2 id=”2″ arg1=”11″] shortcode.
After update/save you will see needed shortcode below there. You can use that shortcode anywhere in your website: in pages, posts, widgets etc.
Just check “Show table-view data below the graph” in order to get table-list view below each chart.
Using “Dynamic Filters” you can create dynamic variables inside SQL code. It also creates corresponding dynamic input form above each chart.
Use this format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type etc.
For example if to put
limit_tag~10~Count~number | post_date_tag~2010-07-05 17:25:18~Date Published~date,
then you can use this SQL code
select * from wp_posts where post_date<{post_date_tag} limit {limit_tag}
in SQL CODE field.
{post_date_tag} and {limit_tag} would be replaced with dynamic variables.
So, the plugin will automatically recognize it and put corresponding selectboxes above the chart.
https://guaven.com/my-sql-charts/
https://guaven.com/my-sql-charts/#docs
Your votes really helps us. Thanks.
Starting from $0 per month.
Rating
Reviewers
21 reviews
Tags
Developed By
Guaven Labs
Quick & Easy
Common Ninja has a large selection of powerful Wordpress plugins that are easy to use, fully customizable, mobile-friendly and rich with features — so be sure to check them out!
Testimonial plugins for Wordpress
Galleries plugins for Wordpress
SEO plugins for Wordpress
Contact Form plugins for Wordpress
Forms plugins for Wordpress
Social Feeds plugins for Wordpress
Social Sharing plugins for Wordpress
Events Calendar plugins for Wordpress
Sliders plugins for Wordpress
Analytics plugins for Wordpress
Reviews plugins for Wordpress
Comments plugins for Wordpress
Portfolio plugins for Wordpress
Maps plugins for Wordpress
Security plugins for Wordpress
Translation plugins for Wordpress
Ads plugins for Wordpress
Video Player plugins for Wordpress
Music Player plugins for Wordpress
Backup plugins for Wordpress
Privacy plugins for Wordpress
Optimize plugins for Wordpress
Chat plugins for Wordpress
Countdown plugins for Wordpress
Email Marketing plugins for Wordpress
Tabs plugins for Wordpress
Membership plugins for Wordpress
popup plugins for Wordpress
SiteMap plugins for Wordpress
Payment plugins for Wordpress
Coming Soon plugins for Wordpress
Ecommerce plugins for Wordpress
Customer Support plugins for Wordpress
Inventory plugins for Wordpress
Video Player plugins for Wordpress
Testimonials plugins for Wordpress
Tabs plugins for Wordpress
Social Sharing plugins for Wordpress
Social Feeds plugins for Wordpress
Slider plugins for Wordpress
Reviews plugins for Wordpress
Portfolio plugins for Wordpress
Membership plugins for Wordpress
Forms plugins for Wordpress
Events Calendar plugins for Wordpress
Contact plugins for Wordpress
Comments plugins for Wordpress
Analytics plugins for Wordpress
Common Ninja Apps
Browse our extensive collection of compatible plugins, and easily embed them on any website, blog, online store, e-commerce platform, or site builder.
Add a testimonials slider to your site to showcase real customer feedback, build credibility, and increase trust that leads to higher conversions.
Present all your locations with a clear company branch list that helps customers find nearby offices, understand key details, and enjoy a smoother experience.
Add interactive stories to your site to showcase content in a visual, mobile friendly format that boosts engagement and guides visitors toward action.
Create business listings with a listings widget that presents companies clearly, supports easy organization, and helps visitors find the right services quickly.

Show WordPress posts with a WordPress feed that keeps content fresh, improves navigation, and helps visitors discover more of your site.
Add announcements to your site to share important updates, keep visitors informed, and guide them toward actions that support engagement and conversions.
Create headlines with background images that blend text and visuals and let you control animation, position, and fonts.
Show Capterra reviews to build trust, strengthen credibility, and help visitors make confident software buying decisions that support higher sales.
Use product blobs to highlight key items, draw attention to featured products, and guide visitors toward faster and more confident purchase decisions.
Show TikTok videos with a TikTok carousel that arranges clips in a smooth, customizable layout to boost engagement and keep visitors watching.
Show Yelp reviews to build trust, strengthen credibility, and help visitors make confident decisions that support higher sales.
Use a payment button for secure PayPal or Stripe checkout to simplify online payments and help increase sales.
More plugins
The Common Ninja Search Engine platform helps website builders find the best site widgets, apps, plugins, tools, add-ons, and extensions! Compatible with all major website building platforms - big or small - and updated regularly, our Search Engine tool provides you with the business tools your site needs!
