Monthly Downloads: 13,334
Programming language: PHP
License: MIT License
Tags: Database     MySQL     Sqlite     Postgresql     SQL     Query Builder     Lightweight     Oracle     Mssql     Php Framework     Mariadb     Database Library    
Latest version: v1.7.10

Medoo alternatives and similar libraries

Based on the "Database" category.
Alternatively, view Medoo alternatives based on common mentions on social networks and blogs.

Do you think we are missing an alternative of Medoo or a related project?

Add another 'Database' Library


The lightweight PHP database framework to accelerate development


  • Lightweight - Portable with only one file.

  • Easy - Easy to learn and use, friendly construction.

  • Powerful - Supports various common and complex SQL queries, data mapping and prevents SQL injection.

  • Compatible - Supports MySQL, MSSQL, SQLite, MariaDB, PostgreSQL, Sybase, Oracle, and more.

  • Friendly - Works well with every PHP framework, like Laravel, Codeigniter, Yii, Slim, and frameworks that are supporting singleton extension or composer.

  • Free - Under the MIT license, you can use it anywhere, whatever you want.


PHP 7.3+ and installed PDO extension.

Get Started

Install via composer

Add Medoo to the composer.json configuration file.

$ composer require catfan/medoo

And update the composer

$ composer update
// Require Composer's autoloader.
require 'vendor/autoload.php';

// Using Medoo namespace.
use Medoo\Medoo;

// Connect the database.
$database = new Medoo([
    'type' => 'mysql',
    'host' => 'localhost',
    'database' => 'name',
    'username' => 'your_username',
    'password' => 'your_password'

// Enjoy
$database->insert('account', [
    'user_name' => 'foo',
    'email' => '[email protected]'

$data = $database->select('account', [
], [
    'user_id' => 50

echo json_encode($data);

// [{
//    "user_name" : "foo",
//    "email" : "[email protected]",
// }]

Contribution Guides

For starting a new pull request, please make sure it's compatible with other databases and write a unit test as possible.

Run phpunit tests for unit testing and php-cs-fixer fix for fixing code style.

Each commit is started with [fix], [feature] or [update] tag to indicate the change.

Please keep it simple and keep it clear.


Medoo is under the MIT license.


*Note that all licence references and agreements mentioned in the Medoo README section above are relevant to that project's source code only.