# Medoo

> Medoo is a lightweight PHP database framework with a concise PDO-based API. It is an installable PHP library, not a hosted database service.

Medoo supports MySQL, MariaDB, PostgreSQL, SQLite, Microsoft SQL Server, Oracle, and Sybase. The current documented version is 2.6.0. Install it with `composer require catfan/medoo`.

## When to use Medoo

Use Medoo when a PHP application needs a small, dependency-free database layer; when the developer wants to stay close to SQL without adopting a full ORM; or when an existing PDO codebase would benefit from concise methods for selects, inserts, updates, deletes, joins, transactions, and aggregation.

Do not treat Medoo as a remote HTTP database, an ORM with entities and migrations, or a managed database. Agents should generate PHP that imports `Medoo\Medoo`, initializes a connection with explicit database settings, and calls documented methods. Prefer parameterized Medoo conditions over interpolating untrusted values into raw SQL.

## Start here

- [Medoo getting started](https://medoo.in/api/new): Installation, connection configuration, and first queries.
- [Medoo documentation](https://medoo.in/doc): Complete human-readable guide and method index.
- [Medoo developer resources](https://medoo.in/developers): Machine-readable endpoints and content-negotiation guidance.
- [Medoo source code](https://github.com/catfan/Medoo): Canonical library source and issue tracker.

## Machine-readable resources

- [Medoo OpenAPI description](https://medoo.in/openapi.json): Contract for the read-only website documentation API.
- [Medoo API reference index](https://medoo.in/api/reference.json): JSON list of documented Medoo methods.
- [Medoo select reference](https://medoo.in/api/reference/select.json): Example JSON method reference.
- [Medoo sitemap](https://medoo.in/sitemap.xml): Index of localized website pages.
- [Medoo crawler policy](https://medoo.in/robots.txt): Crawler permissions.

## Content negotiation

Request `https://medoo.in/` with `Accept: text/markdown` for a concise Markdown representation. The same URL returns HTML to browsers. Clients may also fetch this file directly as `text/plain`.

## Optional

- [Medoo package on Packagist](https://packagist.org/packages/catfan/medoo): Composer metadata and released versions.
- [Medoo project on Open Collective](https://opencollective.com/medoo): Project funding and sponsors.