MMDSolutions

Solutions documentation · Version 1.0.0

SQL Query Optimisation Toolkit: how it works

Turn a SQL review into a clear, evidence-led action list.

Open SQL Query Optimisation ToolkitTry the example

One-off local software. No Hub account or subscription required. Check the tool page for purchase availability.

One clear goal

Produce an evidence-led SQL review, with actionable next steps and official references. This offline toolkit never executes SQL or connects to a database.

Start and review

  1. Extract the purchase ZIP and open index.html in a current Chrome, Edge, Firefox or Safari. Keep the accompanying files together.
  2. Paste SQL or load the fictional example. Choose Review SQL.
  3. Read each prompt, its line number, explanation and next step. The eight checks cover wildcard projections, DISTINCT, nullable NOT IN, leading wildcard searches, deep numeric OFFSET, random ordering, predicate functions and outer UPDATE/DELETE without WHERE.
  4. Optionally paste an existing PostgreSQL JSON plan and review again. Nodes with actual rows show an estimate comparison; differences of at least 10× and zero/nonzero mismatches are marked for review. Rows are per invocation; loops are shown separately.
  5. Download JSON for a structured record or Markdown for a review document. Exports include findings and plan comparisons, not the original SQL text.

Worked example

The supplied query produces seven prompts. Its sample plan estimates 10 rows and reports 1,250 actual rows: a 125× difference. This is a reason to investigate statistics and predicates, not proof of an index requirement or a promised speed improvement.

SQL review of a fictional orders query

Supported scope and limits

Maximum SQL length 250,000 characters; PostgreSQL plan JSON 1,000,000 characters, 2,000 nodes and 100 nested levels. The scanner handles common comments, escaped SQL quotes, quoted identifiers and PostgreSQL dollar strings. It is a heuristic reviewer, not a complete SQL parser or dialect validator. Vendor-specific procedural SQL, backslash escapes, dynamically generated SQL and unusual syntax may produce missed or irrelevant prompts. Review every result.

Only PostgreSQL JSON plans are supported. Estimated-only plans do not have actual counts to compare. No schema, indexes, statistics, row values, timing benchmark or database credentials are inspected. No findings does not establish correctness, safety or optimal performance. Index additions can increase write cost.

Measure safely

Compare results and representative execution plans before and after any change. EXPLAIN ANALYZE actually executes SQL, including side effects. Collect plans in an appropriate environment using your database procedures; this product does not execute or automate that step.

Official references: PostgreSQL EXPLAIN, NOT IN and NULL, SQL Server index design, PostgreSQL LIMIT and OFFSET, index types.

Privacy, purchase and support

Processing is local, without uploads, analytics, accounts or saved browser data. External reference links open only when clicked. £29 once includes version 1.0.0, editable source, examples, tests, this guide, an internal-business-use licence and 90 days of installation support. Future versions and bespoke optimisation work are not promised. Support: support@mmd-solutions.co.uk.

Source and current version

This documentation is generated from the tool’s own versioned guide. See the current Hub guide and tool page for availability and release details.

Contact us

Tell us what you need help with. We’ll reply by email to discuss the next step.

We’ll use your details to reply. This won’t subscribe you to marketing.

How we handle your details

Your enquiry is stored securely and may be emailed to our support inbox. Only authorised staff and our hosting and email providers have access. We keep it only as long as needed to respond and meet record-keeping obligations. To ask about access, correction or deletion, email support@mmd-solutions.co.uk. This form does not subscribe you to marketing.

Or email support@mmd-solutions.co.uk

Help shape MMD

Start with a free 15-minute conversation about the admin taking up your evenings. If there is a fit, choose Callback alone or add enquiry, quote and payment follow-up.

Discuss a paid pilot

From £49 for 30 days + £49 standard setup (£98 first payment), before any applicable VAT. Starts on activation. Continuing after day 30 needs your explicit agreement. No obligation to buy or join a mailing list.

Read the pilot details and allowances

Optional analytics

Privacy and offer details

With your analytics permission, MMD also counts completed admin-estimator calculations by day and broad weekly time-saving range. The estimator does not send entered figures, contact details or a visitor identifier. These aggregate counts describe tool use and assumptions, not verified savings. Our hosting provider still processes ordinary request metadata; hashed network counters are used briefly for rate limiting. Google receives the named calculation event. Rejecting analytics keeps this optional measurement off; the calculator still works.

This website is provided by MMD Solutions Ltd, company 17265591, 15 Neptune Court, Vanguard Way, Cardiff CF24 5PJ. Guides are general information. The phone demo is a live, short-lived demonstration. CRM connections require separate setup and are not enabled by the public demo. Browsing or sending an enquiry creates no paid subscription. Prices, service scope and subscription terms must be agreed before purchase. Nothing here limits statutory consumer rights.

Analytics is optional and separate from the research conversation and paid pilot. Using this website or reading these terms does not subscribe you to email marketing. Contact support@mmd-solutions.co.uk with privacy questions.

If you accept, Google Analytics receives information about visits, device and browser types, traffic sources and interactions. We don’t send your name, email address, phone number or enquiry message to analytics. Advertising features are disabled.

GA4 user and event data is retained for up to 14 months; aggregated reports may be kept longer. We remember your choice on this device for six months. You can change it at any time using Pilot & cookies in the footer. Rejecting stops future analytics collection and removes our Google Analytics cookies; it does not erase data already collected.

MMD Solutions Ltd is responsible for this website’s analytics. Google may process data outside the UK. See how Google uses information from this site and Google’s privacy policy. To ask about your data or your privacy rights, email support@mmd-solutions.co.uk. You can also raise a concern with the Information Commissioner’s Office.

The paid pilot lasts 30 days from activation. Callback costs £49; Callback with either Enquiry & quote follow-up or Invoice & payment reminders costs £68; Callback with both additions costs £87. There is one £49 standard setup fee, making the first payment £98, £117 or £136 respectively. Prices are before any applicable VAT. Standard setup covers compatibility checks, standard configuration, message templates, testing and a handover, with up to one hour of setup time. We confirm availability, compatibility, scope and costs before you agree to start. Each addition includes 50 outgoing SMS segments per service month and normal customer replies. Long texts can use more than one segment. We notify you before the limit and pause additional automated messages at the cap. A £10 prepaid top-up for 100 outgoing segments needs your approval; no automatic overage charges. At day 30 you explicitly choose whether to continue at the same monthly price, held for your first three months. After that agreement, the service renews monthly; you can cancel the next renewal through the billing portal or by contacting us. If you do not continue, we agree how to return call handling to its previous setup. Existing customers pay £19/month per addition and one £49 setup fee to configure one or both additions. Custom integrations are scoped and quoted separately, with third-party fees and any maintenance agreed before work starts. Research participation, marketing and analytics are separate choices. Honest feedback is welcome; no positive review is required and the initial conversation carries no obligation to buy. Callback includes up to 20 voicemail messages or 20 processing minutes per service month, whichever is reached first, for one business number. Each message is counted separately and its duration is rounded up to a whole processing minute: a 20-second message uses 1 minute; a 61-second message uses 2. Messages are limited to 2 minutes. Unused allowance does not roll over. We confirm activation and reset dates, and how calls are handled at the limit, before activation. Extra callback usage must be agreed separately; there are no automatic paid top-ups.

 Chat on WhatsApp