EasySQL WordPress Plugin

Official WordPress Plugin for EasySQL · A Clearsoft Product

Bring the power of natural-language database queries directly into your WordPress admin dashboard. Ask questions about WooCommerce orders, user registrations, custom post types, or analytics in plain English (or Portuguese, Spanish, etc.), and EasySQL will generate and safely execute the SQL query to deliver instant answers, data tables, and interactive charts.

Key Features

• 💬 Ask in Natural Language: Type questions like "How many WooCommerce orders were completed last week?" or "Top 5 most viewed posts this month".
• 📊 Interactive Data Visualizations: Automatic bar charts, line graphs, and pie charts rendered with Chart.js.
• 🔍 SQL Transparency: Inspect the exact SQL query generated before or alongside the results.
• 🛡️ Safe Local Execution: Database schema is synced securely, and queries run directly against your WordPress database using $wpdb.
• ⚡ History & Submenu Navigation: Quickly access past questions, copy generated SQL, or adjust API settings.

Requirements

• WordPress: 5.6 or later
• PHP: 8.2 or later
• EasySQL Account & API Key: Get one at easysql.net

Installation

Option 1: Manual Installation (Release ZIP)

1. Download the latest release from the Releases page.
2. Unzip and upload the easysql-wp folder to your /wp-content/plugins/ directory.
3. Activate EasySQL from the Plugins screen in your WordPress admin dashboard.
4. Go to EasySQL → Settings and enter your API Key.

Option 2: Composer (Bedrock / Roots)

If you manage your WordPress site with Composer:

composer require clearsoft/easysql-wp

Configuration

Navigate to EasySQL → Settings in your WordPress admin panel:

To configure the endpoint programmatically via wp-config.php:

define( 'EASYSQL_ENDPOINT', 'https://api.easysql.net/v1' );
define( 'EASYSQL_API_KEY', 'your-api-key-here' ); // Optional fallback

Use the Test Connection button on the Settings screen to verify your API credentials.

REST API Reference

The plugin provides authenticated REST endpoints (requires manage_options capability and a valid X-WP-Nonce header):

Example Request

curl -X POST https://example.com/wp-json/easysql/v1/query \
  -H "Content-Type: application/json" \
  -H "X-WP-Nonce: <nonce>" \
  -d '{
    "connector_id": "conn_abc123",
    "question": "How many users registered in the last 30 days?"
  }'

Development & Contributing

Contributions are welcome! Please review our Contributing Guidelines for setup instructions and code standards.

git clone https://github.com/Clearsoft-net/easysql-wp.git
cd easysql-wp
composer install
composer test       # run PHPUnit tests
composer lint       # check WordPress Coding Standards (WPCS)
composer lint:fix   # auto-fix style issues

License

This project is open source and licensed under the MIT License.

Maintained by Clearsoft.