Askeet vs SQL Chart Builder

Stop reading dashboards. Talk to your data. A freelance data analyst costs $500–$3,000/month. Askeet does the same job for $19/month, available 24/7, with zero technical skills required. Type a question. Get the answer, the chart, and a recommendation — instantly. Example questions you can ask “Show me my top 10 customers this month” “Which products are selling best by region?” “How does this month’s revenue compare to last month?” “What’s my refund rate over the last 90 days?” “Which customers haven’t ordered in 3 months?” “Plot daily sales for the last 30 days” Each answer comes with interactive charts (line, bar, pie, area), a plain-language summary, and actionable recommendations — no SQL, no dashboards, no learning curve. What’s new in v4 🎨 All-new interface (Reach design system) — chat-first home, 3 focused tabs (Ask · Store health · Automations), Saved Queries as a rail, Chart/Table toggle on every answer, and a cleaner upgrade screen ⚡ Faster & self-contained — self-hosted fonts and charts, zero third-party network calls, cache-busted assets ♿ Accessibility pass — ARIA tabs with keyboard navigation, visible focus, reduced-motion support 🐛 Key fixes — stopped an internal AI prompt leaking into Saved Query labels, restored button contrast (WCAG-AA), fixed answer compression, and honest empty states for zero-data stores What’s new in v3 📊 Interactive charts in answers — bar / line / pie / area, auto-selected by AI from your data shape 🎁 14-day Business trial on install — no credit card, all features unlocked 🔥 Founder’s price $19/mo for life — first 200 customers, locked in forever 💼 Business plan with webhooks, REST API, and multi-store (up to 5 stores) 📚 100+ pre-built insights library — sales, products, customers, orders, inventory, marketing, finance 🩺 Store Health Score with proactive weekly alerts ☕ Monday Morning Brief — weekly digest of your KPIs by email 🧠 Smarter AI — now reads your real database conventions (HPOS-aware, real meta_keys, prefer denormalized lookup tables) for dramatically more accurate SQL Why Askeet changes everything 🚀 Save 10+ hours per week — no more manual reports 💡 Decide in seconds, not days — answers in 5 seconds 📈 Grow your revenue — discover opportunities hidden in your data 🎯 Zero learning curve — if you can ask a question, you can use Askeet 🔒 Your data stays put — only your question is sent to Askeet, never your customer/order data Perfect for Store owners who want answers without learning a dashboard Marketing managers tracking campaign performance Operations / inventory managers watching stock and orders Agencies running multiple WooCommerce stores Anyone tired of opening 5 tabs to answer one question Key features 🎤 Natural-language interface Ask in plain English, French, Spanish, German, Arabic — the plugin adapts to your WordPress language No SQL, no dashboards to learn Conversational follow-ups: “and last month?”, “filter by France only”, “sorted by revenue” 📊 Interactive charts (Pro+) Bar charts for rankings and comparisons Line charts for time-series trends Pie charts for breakdowns and proportions Area charts for cumulative growth Hover tooltips, responsive sizing Persisted in saved reports — re-render on demand 📁 Exports (Pro+) PDF for client/team reports Excel for further analysis CSV for ETL pipelines Up to 10,000 rows per export 📚 100+ insights library Sales: revenue trends, top products, AOV, daily/weekly/monthly views Customers: VIPs, lifetime value, new vs returning, cohorts Inventory: low-stock alerts, out-of-stock, dead stock Orders: status breakdown, refund rate, completion rate Finance: revenue per channel, tax breakdown, gross margin Marketing: campaign performance, conversion by source, abandoned-cart analysis 🩺 Store Health Score Composite 0-100 score across sales, inventory, customers, operations Sub-scores per area Actionable recommendations History trend (Business plan) 🔔 Proactive alerts (Pro+) Pro: 5 weekly alerts (top anomalies and opportunities) Business: unlimited, with custom thresholds 📧 Automated reports Pro: Monday Morning Brief (weekly KPI digest) Business: daily, weekly, and monthly reports 🔌 Outbound webhooks (Business) Slack, n8n, Zapier, Make, custom URLs Fire on report delivery, alert trigger Signed payloads 🔑 REST API (Business) wp-json/askeet/v1/insights, /reports, /health-score Per-install API keys Build your own dashboards or sync with your data warehouse 🏪 Multi-store (Business) Connect up to 5 WooCommerce stores under one account Switch between them in the plugin header Aggregated reports across all stores 🔒 Privacy & security Your customer, order, and product data never leaves your server Only the natural-language question + an anonymized schema dump goes to Askeet GDPR compliant Stripe-secured payments 30-day money-back guarantee Pricing 🆓 Free — $0/mo forever * 50 queries / month * Text answers * 10 starter insights * Community support 💼 Pro — $19/mo billed yearly (or $29/mo monthly) * Unlimited queries * Interactive charts * PDF / Excel / CSV export * Health Score * 5 weekly proactive alerts * Monday Morning Brief * 100+ insights library * Email support (24h) 🚀 Business — $49/mo billed yearly (or $79/mo monthly) * Everything in Pro * Unlimited proactive alerts * Daily + weekly + monthly reports * Slack / n8n / Zapier webhooks * REST API access * Multi-store (up to 5) * Priority support (12h SLA) 🔥 Founder’s price — $19/mo for life (limited to 200 seats) * Same unlimited Pro plan * Locked at $19/mo as long as you stay subscribed * No yearly commitment required 30-day money-back guarantee Not satisfied? Get a full refund within 30 days, no questions asked. Visit https://www.askeet.ai/ to learn more. Source Code The unminified source code for JavaScript and CSS is included in the /assets/js/ and /assets/css/ folders of this plugin. External Services This plugin connects to https://api.askeet.ai to process AI queries, check user plans, and manage subscriptions. Data sent: site URL, install ID, the natural-language question, and an anonymized list of your database table names. No customer, order, or product data is sent. Service provider: Askeet (Reach Technologies) Legal Notice: https://www.askeet.ai/#mentions Privacy Policy: https://www.askeet.ai/#privacy Support & Community Website: https://www.askeet.ai/ Support email: [email protected] Discord: https://discord.com/channels/1438540885758443570/1438540942973079766 Slack: https://reach-technologies.slack.com/archives/C09S953P6MD

The plugin creates 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. 11 chart types: Pie, Doughnut, Polar Area, Radar, Line, Area, Stepped Line, Bar, Horizontal Bar, Stacked Bar, Scatter What’s new in 3.0 A completely redesigned chart builder. No more “nerd-only” settings page: a clean, tabbed UI walks you through Chart & Data → Dynamic Filters → Style → Advanced. Visual chart type picker with built-in guides. Every chart type shows a short “when to use it” guide plus a working example query you can insert with one click. Live SQL autocomplete. Start typing and the editor suggests SQL keywords (type “S” — get SELECT), your real database table names and real column names. Type tablename. to see that table’s columns. Press Ctrl+Space for suggestions at any time. Click-to-build query toolbar. SELECT / COUNT(*) / FROM / WHERE / GROUP BY / ORDER BY / LIMIT buttons plus “Insert table”, “Insert column” and “Insert dynamic tag” dropdowns filled with your actual database schema — build a best-practice query without typing a single word. No-code input filters. Add date/number/text filters as simple rows (tag, type, label, default) — the tag dropdown suggests {tags} already used in your query and columns from its WHERE part. No more memorizing the ~ / | syntax (a raw editor is still available for pros). One click inserts the {tag} into your query. Dropdown column mapping. The X/Y axis fields are dropdowns filled with the columns detected in your SQL query — no more guessing column names. Color pickers instead of typing hex codes, and a fixed professional default palette instead of random colors. Latest Chart.js v4, bundled inside the plugin — no third-party CDN calls, GDPR-friendly. 4 new chart types: Radar, Stepped Line, Stacked Bar and Scatter. Better front-end design: modern table view, restyled filter form and datepicker. Full legacy support: charts created with 2.x keep working unchanged. Deprecated Google-Chart types are automatically mapped to modern equivalents when you open/save the chart. How to use Go to Dashboard → My SQL Charts → Add New and give any name to your report. Pick a chart type — read the short guide shown under the type cards, or click “Use this example” to start from a working query. Build your SQL query with the toolbar buttons and autocomplete (real table and column names are suggested), then map the X and Y columns. You can use multiple SQL queries too — just split them with the “;” sign to get comparison charts. You can also pass shortcode arguments into the query: with “select * from wp_posts where ID>{arg1}” the shortcode [gvn_schart_2 id=”2″ arg1=”11″] passes the value in. After Publish/Update you will see the shortcode below the builder. Use it anywhere on your website: pages, posts, widgets, or the “My SQL Charts” Gutenberg block. Check “Show table-view data below the graph” to also render the data as a styled table. In the Input Filters tab, add filters by clicking “+ Add filter” — each one becomes an input (with a datepicker for date types) above the chart at the front-end. Chart type mini-guide Pie / Doughnut — how a total splits into a few parts. One query: label column + numeric column. Polar Area — like a pie, but the value controls the radius; great for cyclic data (months, weekdays). Radar — compare one or more series across categories arranged in a circle (profiles, ratings). Line — trends over time; add more “;”-separated queries for comparison lines. Area — a line with the region filled; emphasizes volume. Stepped Line — values that change at discrete moments (prices, stock levels). Bar / Horizontal Bar — compare categories; horizontal is best for long labels. Stacked Bar — how each category total is composed; each “;”-separated query becomes one segment. Scatter — correlation between two numeric columns (both X and Y must be numeric). Input filters (dynamic variables) Use the visual rows in the Input Filters tab, or the raw format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type variable_name – any single name you want. default_value – default value when no variable is chosen by the user variable_label – label visible on the form above the chart variable_type – number, text or date ~ separates variable elements, | separates variables Example: with the filters “limit_tag~10~Count~number | post_date_tag~2010-07-05~Date Published~date” you can use “select * from wp_posts where post_date<{post_date_tag} limit {limit_tag}” as the SQL code — the plugin renders the corresponding inputs above the chart automatically. Supported built-in dynamic tags: {current_user_id}, {current_user_login}, {current_user_email}, {current_user_display_name}. Caching Use [gvn_schart_2_cached id=”1″ expire=”3600″] to cache the rendered chart in a transient. Add &force_sql_cache_reload=1 to the URL to bypass it once (e.g. right after upgrading). Website https://guaven.com/my-sql-charts/ Documentation https://guaven.com/my-sql-charts/#docs Bug Submission and Forum Support Contact Page Please Vote if you liked our plugin Your votes really help us. Thanks. Available Filters apply_filters( ‘guaven_sqlcharts_table_empty_cell’); apply_filters(‘guaven_sqlcharts_pre_print_vars’); apply_filters( ‘guaven_sqlcharts_final_output’); apply_filters(‘guaven_sqlcharts_rendered_sql’);