SQL Table Lookup

Slug: sql-table-lookup · harvest316 · 10+

Not updated in last 3 months

Overall Score

Excellent quality and security

92
Excellent

What this score means

Scores are calculated on a 100-point scale by analysing six weighted categories: Security, WP.org Readiness, Performance, Code Quality, Accessibility, and Vulnerabilities.

  • Excellent The plugin follows best practices across every measured category. It is well-maintained, low-risk, and recommended for production use.
  • Good Strong overall quality with minor areas for improvement. Generally safe to use on most sites.
  • Needs Review Some areas of concern detected. Review the full issues report and weigh the risks before installing on production.
  • High Risk Significant quality or security problems found. Exercise caution — check the details carefully before using this plugin.
Score computed: May 21, 2026 7:34 pm (2 hours ago). Vulnerability data mode: Live.
  • Wordfence: May 21, 2026 8:33 pm (51 minutes ago)

No known open vulnerabilities found.

Score Breakdown

Shield
Security
88
Good
Why this score?

Top deductions are based on 1 affected rules, reducing this category by 12 total points.

Rule Hits Impact Share
Security issue: Warning 3 -12 100%
W
WP.org Readiness
75
Good
Why this score?

Top deductions are based on 4 affected rules, reducing this category by 25 total points.

Rule Hits Impact Share
Repo issue: Warning 4 -12 48%
Repo issue: Notice 5 -5 20%
Last update is over one year old 1 -5 20%

Plus 1 additional rules with smaller impact.

Show all rules (1 more)
Rule Hits Impact Share
Tested up to version is behind current WordPress 1 -3 12%
Speed
Performance
100
Excellent
Why this score?

Top deductions are based on 0 affected rules, reducing this category by 0 total points.

No deductions were applied for this category in the latest score run.

Code
Code Quality
97
Excellent
Why this score?

Top deductions are based on 1 affected rules, reducing this category by 3 total points.

Rule Hits Impact Share
Code Quality issue: Warning 1 -3 100%
A11y
Accessibility
100
Excellent
Why this score?

Top deductions are based on 0 affected rules, reducing this category by 0 total points.

No deductions were applied for this category in the latest score run.

Bug
Vulnerability Status
100
Excellent
Why this score?

Top deductions are based on 0 affected rules, reducing this category by 0 total points.

No deductions were applied for this category in the latest score run.

Plugin Details

Scan Summary

  • Errors: 0
  • Warnings: 8
  • Notices: 5
  • Last Scanned: 2026-05-21 18:34:42
Scans are performed automatically once per day.

What Changed Since Last Scan

Comparing latest scan (2026-05-21 18:34:42) to previous scan (2026-05-19 18:12:37).
New: 0 Resolved: 0 Worsened: 0

New Issues

No items in this category.

Resolved Issues

No items in this category.

Worsened Issues

No items in this category.

Detected Issues

Severity Category Message File Fix Guidance
WARNING REPO Plugin metadata is missing a declared minimum PHP version.
Quick Add a "Requires PHP" value in the plugin header and readme metadata.
Moderate Validate minimum PHP compatibility across supported environments and release notes.
Advanced Automate compatibility matrix tests in CI for all declared PHP versions.
WARNING REPO Plugin metadata has no 'Tested up to' value.
Quick Set the "Tested up to" value in readme.txt to the latest stable WordPress release.
Moderate Run smoke tests on current WordPress major/minor versions before publishing updates.
Advanced Adopt automated WordPress-version CI pipelines and gate releases on pass/fail status.
NOTICE REPO Plugin has no icon on WordPress.org.
Quick Upload standard plugin icon assets to the WordPress.org assets directory.
Moderate Provide dark/light-safe icon variants and verify rendering in listing contexts.
Advanced Automate asset packaging validation in release tooling to prevent missing media.
NOTICE REPO Plugin has no header banner on WordPress.org.
Quick Upload the required WordPress.org banner image sizes in SVN assets.
Moderate Create responsive-safe banner designs with legible copy and branding.
Advanced Integrate listing asset checks in the release pipeline with design QA approvals.
NOTICE REPO Plugin is still at pre-release version 0.1.
Quick Set a stable semantic version once production readiness is confirmed.
Moderate Define release criteria and changelog quality gates before promoting stable tags.
Advanced Adopt automated release orchestration with semantic version enforcement and rollback plans.
WARNING SECURITY Declared minimum WordPress 3.0 is very outdated and lacks modern security APIs.
Quick Raise minimum WordPress version to a modern supported release.
Moderate Replace deprecated APIs and confirm compatibility across current WordPress branches.
Advanced Run multi-version WordPress integration tests in CI and block unsupported API usage.
WARNING REPO Main plugin file does not declare a Text Domain header. sql-table-lookup.php
Quick Add a Text Domain header so translation tooling and WordPress.org can identify the plugin textdomain.
Moderate Apply the same remediation pattern across repo findings and re-scan to confirm warning issues drop.
Advanced Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.
NOTICE REPO Main plugin file does not declare a Domain Path header. sql-table-lookup.php
Quick Add a Domain Path header if language files are stored in a languages directory.
Moderate Apply the same remediation pattern across repo findings and re-scan to confirm notice issues drop.
Advanced Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.
WARNING SECURITY Main plugin file does not appear to guard direct access with an ABSPATH check. sql-table-lookup.php
Quick Add an ABSPATH guard near the top of the main plugin file to prevent direct execution.
Moderate Apply the same remediation pattern across security findings and re-scan to confirm warning issues drop.
Advanced Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.
NOTICE REPO Plugin package does not include a license file.
Quick Add a LICENSE or COPYING file so distribution terms are explicit.
Moderate Apply the same remediation pattern across repo findings and re-scan to confirm notice issues drop.
Advanced Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.
WARNING SECURITY Direct database query detected without an immediately visible $wpdb->prepare() wrapper. sql-table-lookup.php
Quick Wrap dynamic SQL arguments with $wpdb->prepare() in the flagged query.
Moderate Refactor repeated SQL into repository/helper methods that enforce prepared statements by default.
Advanced Add integration tests and static checks that fail builds when direct dynamic SQL is introduced.
WARNING CODE_QUALITY No WordPress hooks were detected in the plugin source.
Quick Register actions, filters, and lifecycle hooks explicitly so plugin behavior integrates cleanly with WordPress.
Moderate Apply the same remediation pattern across code quality findings and re-scan to confirm warning issues drop.
Advanced Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.
WARNING REPO No translation functions were detected in the plugin source.
Quick Wrap user-facing strings with translation functions such as __(), esc_html__(), or _x().
Moderate Apply the same remediation pattern across repo findings and re-scan to confirm warning issues drop.
Advanced Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.

Score History

Range Change: 0 pts · All-Time High: 92/100