Need help with Medoo?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

4.4K Stars 1.1K Forks MIT License 635 Commits 23 Opened issues


The lightweight PHP database framework to accelerate the development.

Services available


Need anything else?

Contributors list

Build Status Total Downloads Latest Stable Version License Backers on Open Collective Sponsors on Open Collective

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 framework 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 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_name', 'email' ], [ '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.


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

Each commit is started with

tag to indicate the change.

Please keep it simple and keep it clear.


Medoo is under the MIT license.


We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.