catfan/Medoo

Health v2 · maintenance only

Adoption not part of the score

4947 stars · 1131 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

Medoo is a lightweight, single-file PHP database framework that provides a clean, intuitive API for building SQL queries across many database engines. It uses PDO and prepared statements to support MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, Oracle, Sybase, and more.

Use cases

• query a mysql database from php without writing raw sql
• build a crud api with insert select update delete in php
• use prepared statements to prevent sql injection
• run database queries across mysql postgresql and sqlite with one api
• integrate a lightweight database layer into laravel or slim
• perform aggregate queries like count sum max avg in php
• execute database transactions in php

When to choose

• you want a tiny, dependency-free database layer for a PHP project
• you need a simple query builder instead of a full ORM
• you work with multiple SQL database engines and want one consistent API
• you want quick database access inside any PHP framework

When to avoid

• you need a full ORM with entities, migrations, and relations like Doctrine or Eloquent
• you use a non-PHP language
• you need advanced features like lazy loading or unit-of-work persistence

Facets

library · maturity stable

database orm database-driver databases web-development backend developer-tools php cross-platform sql-builder pdo query-builder lightweight mysql postgresql sqlite mssql prepared-statements

Member repositories

For agents

markdown · JSON · MCP: product_card(name="catfan/Medoo")