

Get in touch

Download Plugin Now
  • Follow
  • Follow
WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
    • Tool Guide
    • App Builder
    • Data Explorer
    • SQL Query Builder
    • Plugin Settings
    • Legacy Tools
    • Remote Connections
a
M
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
    • Tool Guide
    • App Builder
    • Data Explorer
    • SQL Query Builder
    • Plugin Settings
    • Legacy Tools
    • Remote Connections
Download Plugin Now

SQL Query Builder

  • Getting Started
  • Writing queries
  • AI Assistant
  • Schedule queries
  • Data exchange
  • WordPress user ID in SQL
  • Stored procedures
  • Database triggers
  • Visual Query Builder
View Categories

Getting Started

The SQL Query Builder in WP Data Access empowers admin users to write, store, execute, reuse, and schedule any SQL command—or even a sequence of multiple commands—directly from the WordPress dashboard, provided the user has the necessary credentials. Designed exclusively for administrators, the tool includes built-in safeguards that block access to core WordPress tables by default to prevent accidental data corruption.

This feature-rich tool supports a tabbed interface, enabling multiple SQL queries to be edited and executed in parallel. Queries can be saved either privately (per user) or globally (shared among admins), making it easy to collaborate or work independently. Results can be exported to CSV, JSON, or XML formats, and plugin users can connect to both local and remote databases. For deeper diagnostics or debugging, the raw server response is available for inspection.

Version 5.5.41 introduces the new and improved SQL Query Builder—enhancing usability while maintaining backward compatibility. The Visual Query Builder is still accessible through the legacy interface via the “Switch to old Query Builder” link in the top-right corner of the screen.

Key Features in the New SQL Query Builder #

  • Schedule SQL queries to run automatically at defined intervals
  • Parameter support for scheduled queries
  • AI Assistant to help write, refine, and troubleshoot SQL queries
  • Save queries privately or share them globally among admins
  • Import SQL from external files for quick reuse
  • Export queries to external files for backup or sharing
  • Full-screen editing and analysis
  • Execute SQL on remote or local databases
  • Export query results to CSV, JSON, or XML
  • Inspect raw server responses for debugging or advanced research
  • Tabbed UI for managing multiple queries simultaneously
  • Automatic protection of WordPress core tables
SQL Query Builder
Share This Article :
  • Facebook
  • X
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2025-05-22
Writing queries

6 Comments

  1. Ianj
    Ianj on 2021-05-30 at 1:33 pm

    Is it possible to create a search box on the front-end (i.e., on the website) in which users can input sql command instead of a keyword based search box?

    Reply
    • Peter Schulz
      Peter Schulz on 2021-05-31 at 6:50 am

      Hi Ian,

      It is possible but too risky. WordPress uses one user account to connect to the database. That user account can access all tables in your WordPress database. If you give website visitors access to sql, you give them accesss to your WordPress tables…

      For publications you might consider the search builder. The search builder has some restrictions but allows visitors to create field based queries. A demo can be found here:
      https://wpdataaccess.com/search-builder-demo/

      Hope this helps,
      Peter

      Reply
  2. rick harper
    rick harper on 2024-12-01 at 6:22 pm

    once I have created a successful SQL query can I move it to a WordPress page or can I only run it from SQL app

    Reply
    • Kim Leong
      Kim Leong on 2024-12-02 at 11:35 am

      Hi Rick,

      Any query ran with our SQL Query Builder is valid. For example, if you run a Create Table query, a table will be created in your WordPress database, and you can then use it however you wish in your site. Hope that helps!

      Reply
  3. rick harper
    rick harper on 2024-12-01 at 6:25 pm

    when I import a local data base and set it up so users can modify it am I modifying the table on my hosting server or is the new table stored elsewhere.

    Reply
    • Kim Leong
      Kim Leong on 2024-12-02 at 11:38 am

      Hi Rick,

      If you modify/alter the table using WP Data Access, you are modifying the table in your database directly. No new table is created unless you duplicate your table. Hope that answers your question!

      Reply

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Table of Contents
  • Key Features in the New SQL Query Builder
WP Data Access
  • Follow
  • Follow
Links
$

Imprint

$

Privacy policy

$

Cookie policy

Get in touch
$

Contact us

$

Free support forum

$

Premium support

Resources


WordPress plugin directory



YouTube tutorials

Copyright © 2025 | All Right Reserves

Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}