关于
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.
主要功能
- 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
使用案例
- Automating database schema migrations and management tasks.
- Building backend services that require dynamic database interaction.
- Developing custom administrative interfaces for MySQL or PostgreSQL databases.