MyPos
Provides a comprehensive set of tools for interacting with and administering MySQL and PostgreSQL database schemas and data.
About
MyPos is an MCP (Model-Context-Protocol) server designed for robust database management. It seamlessly connects to both MySQL and PostgreSQL databases, offering a wide array of functionalities to interact with and administer your database schema and data. From listing tables and executing SQL queries to creating, modifying, and deleting tables, columns, and foreign keys, MyPos empowers developers with a programmatic interface to manage their databases efficiently. It also supports data insertion, full CRUD operations on any table, and convenient data import/export capabilities in CSV or JSON formats, making it a versatile tool for database-driven applications.
Key Features
- Connects to MySQL and PostgreSQL databases.
- Comprehensive schema management (create, delete, rename tables; add, remove, rename, change column types).
- Data manipulation including insert, select, and full CRUD operations.
- Foreign key management (add and delete).
- Data import and export to/from CSV and JSON formats.
- 0 GitHub stars
Use Cases
- Automating database schema migrations and management tasks.
- Building backend services that require dynamic database interaction.
- Developing custom administrative interfaces for MySQL or PostgreSQL databases.
