# MyDuck Server

> MyDuck Server is a self-hosted, open-source analytics server with MySQL/PostgreSQL wire protocols and DuckDB's OLAP engine for 1000x faster queries.

- **Category:** Databases
- **Licence:** Apache-2.0
- **Open source:** oss
- **Languages:** Go
- **Platforms:** Docker, Docker Compose
- **Tags:** Analytics, PostgreSQL, Business Intelligence, Mcp, MySQL, Duckdb, Databases, MariaDB, Data Engineering, Data Science, SQL, Replication, Olap, Parquet, Htap, Columnar, Columnar storage, Postgres, Business Analytics, Arrow, Zero Etl, Flight SQL, Pandas, Polars

## Description

MyDuck Server is an open-source analytics server that lets MySQL and PostgreSQL users run analytical queries at DuckDB speeds without leaving their familiar ecosystem. It implements both MySQL and PostgreSQL wire protocols, allowing any compatible client to connect and execute queries that are translated and executed by DuckDB's columnar OLAP engine. The server supports zero-ETL real-time replication from MySQL (via GTID-based replication) and PostgreSQL (via logical replication), making it a drop-in analytical replica. It also runs in standalone mode as a DuckDB server accessible via PostgreSQL protocol. Key capabilities include HTAP architecture support via ProxySQL or PGPool-II, end-to-end columnar I/O with Parquet/Arrow formats, bulk data loading via LOAD DATA and COPY commands, backup/restore to S3-compatible object storage, and integration with LLM applications via Model Context Protocol (MCP). The project is developed by ApeCloud and released under Apache-2.0 license. No stable releases have been published yet; the Docker image uses the 'latest' tag.

## Links

- [Homepage](https://github.com/apecloud/myduckserver)
- [Website](https://myduck.io)
- [Docker](apecloud/myduckserver)
- [Documentation](https://myduck.io/resources/docs/)
- [GitHub Repository](https://github.com/apecloud/myduckserver)
- [Discord Community](https://discord.gg/9MC5cgw5YK)
- [Blog](https://myduck.io/resources/blog/)

---
Source: https://selfhost.directory/project/myduckserver