catfan/medoo

The lightweight PHP database framework to accelerate development

1,634,493 4,949

database sql mysql sqlite postgresql lightweight mssql oracle php framework mariadb database library

Install
`composer require catfan/medoo`
Latest Version:	v2.6.0
PHP:	>=7.3
License:	MIT
Last Updated:	Oct 12, 2026
Links:	GitHub · Packagist

Maintainer: catfan

The lightweight PHP database framework to accelerate development.

Documentation

Features

Lightweight - A lightweight single-file package that keeps dependencies to a minimum.
Easy - A clean, intuitive API that helps you get started quickly.
Powerful - Designed for complex SQL, data mapping, and prepared statements without sacrificing readability.
Compatible - Works smoothly with MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, Oracle, Sybase, and more.
Friendly - Fits naturally into Laravel, CodeIgniter, Yii, Slim, and other PHP frameworks.
Free - Released under the MIT license and free to use in personal or commercial projects.

Requirements

PHP 7.3 or later
PDO extension enabled

Get Started

Install via composer

Add Medoo to the composer.json configuration file.

$ composer require catfan/medoo

Then update Composer

$ composer update

// Load Composer's autoloader.
require 'vendor/autoload.php';

// Import the Medoo namespace.
use Medoo\Medoo;

// Create a database connection.
$database = new Medoo([
    'type' => 'mysql',
    'host' => 'localhost',
    'database' => 'name',
    'username' => 'your_username',
    'password' => 'your_password'
]);

// Insert data.
$database->insert('account', [
    'user_name' => 'foo',
    'email' => 'foo@bar.com'
]);

// Retrieve data.
$data = $database->select('account', [
    'user_name',
    'email'
], [
    'user_id' => 50
]);

echo json_encode($data);

// [{
//    "user_name" : "foo",
//    "email" : "foo@bar.com",
// }]

Contribution Guidelines

Before submitting a pull request, ensure compatibility with multiple database engines and include unit tests when possible.

Testing & Code Style

Run phpunit tests to execute unit tests.
Use php-cs-fixer fix to enforce code style consistency.

Commit Message Format

Each commit should begin with a tag indicating the type of change:

[fix] for bug fixes
[feature] for new features
[update] for improvements

Keep contributions simple and well-documented.

License

Medoo is released under the MIT License.

[More Products We Build]

Gear Browser - AI Extension Web Browser

Related Packages

repat/laravel-medoo

Laravel Facade and ServiceProvider for The Lightest PHP database framework to ac...

248 5

database laravel lightweight lumen mariadb mssql mysql oracle php framework postgresql sql sqlite

ramadan/custom-fresh

A Laravel package to specify the tables that you do not want to drop while refre...

5,421 61

custom-fresh database laravel mariadb migrate mssql mysql oracle pdo pgsql postgresql queryobject refreshing sql sqlite sqlserver

doctrine/dbal

Powerful PHP database abstraction layer (DBAL) with many features for database s...

644,549,754 9,698

abstraction database db2 dbal mariadb mssql mysql oci8 oracle pdo pgsql postgresql queryobject sasql sql sqlite sqlserver sqlsrv

tommyknocker/pdo-database-class

Framework-agnostic PHP database library with unified API for MySQL, MariaDB, Pos...

6,504 81

activerecord ai-analysis ai-database-assistant ai-powered anthropic batch-processing bulk-operations cli-tools common-table-expressions connection-pooling connection-retry cross-apply cross-platform csv-loader cte cursor-pagination database database-abstraction-layer database-optimization-ai dbal ddl deepseek delete-join dialect-specific-types distinct-on dump error-diagnostics event-dispatcher except exception-hierarchy explain-analysis export-helpers filter-clause fluent-api framework-agnostic full-text-search google-ai helper-functions insert-select intersect json-loader lateral-join lightweight load-balancing mariadb merge-statements microsoft-ai migrations mssql mysql ollama openai oracle orm outer-apply pagination pdo pdo-db pdo-oci pdodb performance php8 plugin-system postgresql prepared-statements psr-14 psr-16 query-builder query-caching query-compilation-cache query-debugging query-macros query-monitoring query-optimization-ai query-profiling query-scopes read-write-splitting recursive-cte regexp relationships restore savepoints schema-builder schema-inspector schema-introspection security seeds set-operations sharding sql-builder sql-formatter sql-injection sql-server sqlite table-locking transactions type-safe union update-join upsert user-management validation window-functions xml-loader yandex-ai yii2-inspired zero-dependencies

absolutelydigital/medoo-laravel