PHPackages                             agento/core - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility & Helpers](/categories/utility)
4. /
5. agento/core

ActiveMagento2-module[Utility & Helpers](/categories/utility)

agento/core
===========

AI-powered development tools for Magento - MCP server integration, SQL queries, cache management, and n98-magerun2 integration

201PHP

Since Nov 24Pushed 5mo agoCompare

[ Source](https://github.com/Genaker/Agento_MCP)[ Packagist](https://packagist.org/packages/agento/core)[ RSS](/packages/agento-core/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependenciesVersions (1)Used By (0)

Agento MCP - AI-Powered Development Tools for Magento 2
=======================================================

[](#agento-mcp---ai-powered-development-tools-for-magento-2)

**Transform your Magento development workflow with AI-powered tools!** 🚀

Agento MCP brings the power of Model Context Protocol (MCP) to Magento 2, enabling seamless AI integration with Cursor IDE, Claude, and other AI assistants. Execute SQL queries, manage cache, and access 100+ magerun commands - all through natural language in your IDE.

[![image](https://private-user-images.githubusercontent.com/9213670/517644233-dcfc4743-4bd1-414e-b492-1143ca6a1495.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzU0MzM5ODQsIm5iZiI6MTc3NTQzMzY4NCwicGF0aCI6Ii85MjEzNjcwLzUxNzY0NDIzMy1kY2ZjNDc0My00YmQxLTQxNGUtYjQ5Mi0xMTQzY2E2YTE0OTUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDQwNiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA0MDZUMDAwMTI0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YzYyNjVkODExNzY3M2E3ZDc2OTlhMDI4MTllNTkzNTI1MDdlMzg4Nzc3OTNmNTNhNmYzNzhiZTRkNzNmYWZlNiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.90uono9b8ySq2PQFz-nS7Lr_cX0nu7miAYIsdYww_Gg)](https://private-user-images.githubusercontent.com/9213670/517644233-dcfc4743-4bd1-414e-b492-1143ca6a1495.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzU0MzM5ODQsIm5iZiI6MTc3NTQzMzY4NCwicGF0aCI6Ii85MjEzNjcwLzUxNzY0NDIzMy1kY2ZjNDc0My00YmQxLTQxNGUtYjQ5Mi0xMTQzY2E2YTE0OTUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDQwNiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA0MDZUMDAwMTI0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YzYyNjVkODExNzY3M2E3ZDc2OTlhMDI4MTllNTkzNTI1MDdlMzg4Nzc3OTNmNTNhNmYzNzhiZTRkNzNmYWZlNiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.90uono9b8ySq2PQFz-nS7Lr_cX0nu7miAYIsdYww_Gg)Why Agento MCP?
---------------

[](#why-agento-mcp)

- ⚡ **Faster Development**: No more context switching between terminal and IDE
- 🤖 **AI-Powered**: Natural language commands for Magento operations
- 🔧 **Comprehensive**: Access to SQL, cache, magerun, and more
- 🎯 **Developer-Friendly**: Built for Magento developers by Magento developers
- 📦 **Easy Installation**: Works with any Magento 2.4+ installation
- ✅ **Zero Configuration**: Works out of the box after installation

Features
--------

[](#features)

- **MCP Server Integration**: Full Model Context Protocol support for Cursor IDE and other AI tools
- **SQL Query Execution**: Run SQL queries directly through AI chat or command line
- **Cache Management**: Clear Magento cache with simple natural language commands
- **n98-magerun2 Integration**: Access to 100+ magerun commands via AI
- **Redis Support**: Flush Redis cache directly through MCP tools
- **Multiple Output Formats**: JSON, CSV, and table formats for query results
- **Natural Language Interface**: Query admin users, orders, products, and more using plain English

Installation
------------

[](#installation)

### Option 1: Install via Composer (Recommended)

[](#option-1-install-via-composer-recommended)

```
composer require genaker/agento-mcp
php bin/magento module:enable Agento_Core
php bin/magento setup:upgrade
php bin/magento cache:clean
```

### Option 2: Manual Installation

[](#option-2-manual-installation)

1. Clone or download this repository to `app/code/Agento/Core`
2. Enable the module:

```
php bin/magento module:enable Agento_Core
php bin/magento setup:upgrade
php bin/magento cache:clean
```

### Step 3: Install n98-magerun2 (Optional but Recommended)

[](#step-3-install-n98-magerun2-optional-but-recommended)

Agento integrates with n98-magerun2 for additional Magento CLI tools. To install:

```
cd /var/www/html/magento
curl -sS -o bin/n98-magerun2.phar https://files.magerun.net/n98-magerun2.phar
chmod +x bin/n98-magerun2.phar
```

Verify installation:

```
php bin/n98-magerun2.phar --version
```

For more information, visit:

### Step 4: Verify Installation

[](#step-4-verify-installation)

Check that the commands are available:

```
php bin/magento list | grep agento
```

You should see:

- `agento:query` - Execute SQL query
- `agento:cache:clear` - Clear cache
- `agento:mcp` - Start MCP server
- `agento:magerun:install` - Install n98-magerun2
- `agento:cursor:install` - Install Cursor MCP server configuration

You should see:

- `agento:cache:clear` - Clear Magento cache
- `agento:query` - Execute SQL query
- `agento:quick` - Clear cache and run query
- `agento:mcp` - Start MCP server

Usage
-----

[](#usage)

### Execute SQL Query

[](#execute-sql-query)

```
php bin/magento agento:query --query "SELECT * FROM admin_user LIMIT 5"
```

With different output formats:

```
# Table format (default)
php bin/magento agento:query --query "SELECT * FROM admin_user LIMIT 5" --format table

# JSON format
php bin/magento agento:query --query "SELECT * FROM admin_user LIMIT 5" --format json

# CSV format
php bin/magento agento:query --query "SELECT * FROM admin_user LIMIT 5" --format csv
```

Using a different database connection:

```
php bin/magento agento:query --query "SELECT * FROM admin_user" --connection indexer
```

### Clear Cache

[](#clear-cache)

```
# Clear all cache
php bin/magento agento:cache:clear

# Clear specific cache type
php bin/magento agento:cache:clear --type config
```

Cursor Integration (MCP Server)
-------------------------------

[](#cursor-integration-mcp-server)

### Quick Install (Recommended)

[](#quick-install-recommended)

Run the automated installer:

```
php bin/magento agento:cursor:install
```

This command will:

- Detect your Magento installation path
- Generate the MCP server configuration
- Attempt to automatically add it to Cursor settings (if Cursor config is found)
- Save the configuration to `cursor-mcp-config.json` for manual installation

### Manual Installation

[](#manual-installation)

If automatic installation doesn't work, follow these steps:

1. Open Cursor settings
2. Navigate to **Features** → **Model Context Protocol**
3. Add a new MCP server with the following configuration:

**For Cursor Settings (JSON):**

```
{
  "mcpServers": {
    "agento": {
      "command": "php",
      "args": [
        "/var/www/html/magento/bin/magento",
        "agento:mcp"
      ],
      "cwd": "/var/www/html/magento"
    }
  }
}
```

**Note**: Adjust the paths (`/var/www/html/magento`) to match your Magento installation directory.

### Step 2: Verify MCP Server Connection

[](#step-2-verify-mcp-server-connection)

1. Restart Cursor after adding the MCP configuration
2. The MCP server should automatically connect
3. You can verify by checking Cursor's MCP server status

### Step 3: Test MCP Server

[](#step-3-test-mcp-server)

You can test the MCP server manually:

```
# Start the MCP server (for testing)
php bin/magento agento:mcp
```

The server will listen on stdin/stdout for JSON-RPC 2.0 protocol messages.

Available MCP Tools
-------------------

[](#available-mcp-tools)

Once connected, the following tools are available to AI assistants:

1. **execute\_sql** - Execute SQL query against Magento database

    - Parameters:
        - `query` (required): SQL query to execute
        - `connection` (optional): Database connection name (default: "default")
2. **clear\_cache** - Clear Magento cache

    - Parameters:
        - `type` (optional): Cache type to clear (clears all if not specified)
3. **magerun** - Execute any n98-magerun2 command (Swiss army knife for Magento)

    - Parameters:
        - `command` (required): Full magerun command (e.g., "db:query", "cache:clean", "sys:info", "admin:user:list")
        - `arguments` (optional): Command arguments as key-value pairs
        - `options` (optional): Command options as key-value pairs
    - Examples:
        - `{"command": "sys:info"}` - Get system information
        - `{"command": "db:query", "arguments": {"query": "SELECT * FROM admin_user LIMIT 5"}}` - Run database query
        - `{"command": "cache:clean", "options": {"type": "config"}}` - Clean specific cache type
        - `{"command": "admin:user:list"}` - List admin users
4. **magerun\_db** - Database operations (query, dump, import, info, console, create, drop, status, variables)

    - Parameters:
        - `command` (required): One of: query, dump, import, info, console, create, drop, status, variables
        - `arguments` (optional): Command-specific arguments
5. **magerun\_cache** - Cache operations (clean, flush, enable, disable, list, status, view, report)

    - Parameters:
        - `command` (required): One of: clean, flush, enable, disable, list, status, view, report
        - `arguments` (optional): Command-specific arguments (e.g., `{"type": "config"}` for clean)
6. **magerun\_admin** - Admin user management (list, create, change-password, delete, activate, deactivate, unlock)

    - Parameters:
        - `command` (required): One of: user:list, user:create, user:change-password, user:delete, user:activate, user:deactivate, user:unlock, token:create
        - `arguments` (optional): Command-specific arguments
7. **magerun\_sys** - System information (info, check, store:list, website:list, url:list, cron:list, cron:run)

    - Parameters:
        - `command` (required): One of: info, check, store:list, website:list, url:list, cron:list, cron:run, maintenance
        - `arguments` (optional): Command-specific arguments
8. **magerun\_config** - Configuration management (store:get, store:set, env:set, search, show)

    - Parameters:
        - `command` (required): One of: store:get, store:set, env:set, search, show, show:urls, show:default-url, show:store-url
        - `arguments` (optional): Command-specific arguments (e.g., `{"path": "web/unsecure/base_url"}` for store:get)
9. **magerun\_customer** - Customer management (list, create, info, delete, change-password, add-address)

    - Parameters:
        - `command` (required): One of: list, create, info, delete, change-password, add-address, token:create
        - `arguments` (optional): Command-specific arguments
10. **magerun\_indexer** - Indexer operations (reindex, reset, status, set-mode, show-mode, info)

    - Parameters:
        - `command` (required): One of: reindex, reset, status, set-mode, show-mode, info, set-status
        - `arguments` (optional): Command-specific arguments
11. **magerun\_module** - Module management (enable, disable, status, uninstall)

    - Parameters:
        - `command` (required): One of: enable, disable, status, uninstall
        - `arguments` (optional): Command-specific arguments (e.g., `{"module": "Magento_Catalog"}`)
12. **magerun\_setup** - Setup operations (upgrade, install, db:status, di:compile, static-content:deploy)

    - Parameters:
        - `command` (required): One of: upgrade, install, db:status, di:compile, static-content:deploy, backup, rollback, uninstall
        - `arguments` (optional): Command-specific arguments

**Note**: For a complete list of all available magerun commands, visit:

Testing the Installation
------------------------

[](#testing-the-installation)

### Test 1: Verify Commands are Available

[](#test-1-verify-commands-are-available)

```
php bin/magento list | grep agento
```

Expected output:

```
agento:cache:clear          Clear Magento cache
agento:mcp                  Start Agento MCP server for AI integration
agento:query                Execute SQL query against Magento database
agento:quick                Clear cache and execute SQL query in one command

```

### Test 2: Test SQL Query Command

[](#test-2-test-sql-query-command)

```
php bin/magento agento:query --query "SELECT VERSION() as mysql_version"
```

Expected output:

```
+-------------------------+
| mysql_version           |
+-------------------------+
| 8.0.42-0ubuntu0.24.04.2 |
+-------------------------+
Rows returned: 1 | Execution time: X.XXms

```

### Test 3: Test Cache Clear Command

[](#test-3-test-cache-clear-command)

```
php bin/magento agento:cache:clear
```

Expected: Should show cache types being cleared.

### Test 4: Test Quick Command

[](#test-4-test-quick-command)

```
php bin/magento agento:quick --query "SELECT COUNT(*) as total FROM admin_user"
```

Expected: Should show:

1. "Clearing cache..." message
2. "✓ All cache cleared" or "✓ Cleared cache type: X"
3. "Executing query..." message
4. Query results in table format
5. Row count and execution time

### Test 5: Test MCP Server (Manual)

[](#test-5-test-mcp-server-manual)

Create a test file `test_mcp.json`:

```
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/list"
}
```

Then test:

```
echo '{"jsonrpc":"2.0","id":1,"method":"tools/list"}' | php bin/magento agento:mcp
```

Expected: Should return a JSON response with available tools.

Troubleshooting
---------------

[](#troubleshooting)

### Command Not Found

[](#command-not-found)

If commands are not available:

```
php bin/magento module:enable Agento_Core
php bin/magento setup:upgrade
php bin/magento cache:clean
```

### MCP Server Not Connecting

[](#mcp-server-not-connecting)

1. Verify the path to `bin/magento` is correct in Cursor settings
2. Ensure PHP is in your system PATH
3. Check Cursor's MCP server logs for errors
4. Test the MCP server manually using the test above

### Database Connection Errors

[](#database-connection-errors)

Ensure your `app/etc/env.php` has correct database credentials:

```
'db' => [
    'connection' => [
        'default' => [
            'host' => '127.0.0.1',
            'dbname' => 'magento',
            'username' => 'magento',
            'password' => 'magento'
        ]
    ]
]
```

Examples
--------

[](#examples)

### Example 1: Get All Admin Users

[](#example-1-get-all-admin-users)

```
php bin/magento agento:query --query "SELECT user_id, username, email, is_active FROM admin_user"
```

### Example 2: Get Product Count by Status

[](#example-2-get-product-count-by-status)

```
php bin/magento agento:query --query "SELECT status, COUNT(*) as count FROM catalog_product_entity GROUP BY status"
```

### Example 4: Export Data as JSON

[](#example-4-export-data-as-json)

```
php bin/magento agento:query --query "SELECT * FROM admin_user LIMIT 5" --format json > users.json
```

### Example 5: Using n98-magerun2 Commands

[](#example-5-using-n98-magerun2-commands)

You can also use n98-magerun2 commands directly:

```
# Get system information
php bin/n98-magerun2.phar sys:info

# Run database query
php bin/n98-magerun2.phar db:query "SELECT * FROM admin_user LIMIT 5"

# List admin users
php bin/n98-magerun2.phar admin:user:list

# Clean cache
php bin/n98-magerun2.phar cache:clean

# Get store list
php bin/n98-magerun2.phar sys:store:list
```

**Note**: These commands are also available through the MCP server for AI assistants in Cursor.

Requirements
------------

[](#requirements)

- Magento 2.4.x
- PHP 7.4 or higher
- MySQL/MariaDB database

License
-------

[](#license)

This module is provided as-is for development purposes.

Testing
-------

[](#testing)

Standalone tests are available that run commands as isolated processes (simulating how Cursor/MCP would call them):

```
# Run all tests
php app/code/Agento/Core/tests/run-standalone-tests.php
```

See `tests/README.md` for more details.

Perfect For
-----------

[](#perfect-for)

- **Magento developers** using Cursor IDE or other AI coding assistants
- **Development teams** wanting to streamline workflows
- **Developers** exploring AI-assisted coding
- **Anyone managing Magento stores** who wants faster access to data and operations

Real-World Examples
-------------------

[](#real-world-examples)

Once set up, you can use natural language commands in Cursor:

- "Show me all active admin users"
- "What's the last order?"
- "Clear the config cache"
- "How many customers do we have?"
- "List all Magento stores"
- "Get the customer with the most orders"

The AI will automatically use the appropriate MCP tools to execute these requests!

Support
-------

[](#support)

For issues or questions, please check:

- [GitHub Repository](https://github.com/Genaker/Agento_MCP)
- [Magento documentation](https://devdocs.magento.com/)
- [Cursor MCP documentation](https://docs.cursor.com/)
- Module code in `app/code/Agento/Core/`
- Test suite in `app/code/Agento/Core/tests/`

Contributing
------------

[](#contributing)

Contributions are welcome! Please feel free to submit a Pull Request.

License
-------

[](#license-1)

MIT License - See LICENSE file for details

Built with ❤️ for the Magento community.

###  Health Score

18

—

LowBetter than 8% of packages

Maintenance48

Moderate activity, may be stable

Popularity4

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity13

Early-stage or recently created project

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/2614da2cb514a3749cd296d237c9ca3430f4dafa09b4e49e338a6b1794a5acf4?d=identicon)[genaker](/maintainers/genaker)

---

Top Contributors

[![Genaker](https://avatars.githubusercontent.com/u/9213670?v=4)](https://github.com/Genaker "Genaker (1 commits)")

### Embed Badge

![Health badge](/badges/agento-core/health.svg)

```
[![Health](https://phpackages.com/badges/agento-core/health.svg)](https://phpackages.com/packages/agento-core)
```

###  Alternatives

[thalidzhokov/country-codes

CountryCodes PHP Class to get array of countries with ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric and ISD codes it can provide following information related to country

13111.5k](/packages/thalidzhokov-country-codes)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)