mcp-database-server

mcp-database-server

3.6

If you are the rightful owner of mcp-database-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The MCP Database Server provides database access capabilities to Claude, supporting SQLite, SQL Server, and PostgreSQL databases.

The MCP Database Server is a versatile tool designed to facilitate database interactions for Claude, a model context protocol server. It supports multiple database systems, including SQLite, SQL Server, and PostgreSQL, allowing users to execute a variety of database operations such as reading, writing, and modifying data. The server can be used directly by installing it globally or through local development setups, providing flexibility for different user needs. It includes a range of tools for database management, such as executing queries, creating and altering tables, and exporting data. The server is built using Node.js and requires version 18 or higher. It also provides detailed documentation and setup guides for connecting to SQL Server and PostgreSQL databases, making it accessible for users with varying levels of technical expertise.

Features

  • Supports multiple databases: SQLite, SQL Server, and PostgreSQL.
  • Offers tools for executing queries, creating tables, and exporting data.
  • Flexible usage options: direct global installation or local development.
  • Comprehensive documentation and setup guides.
  • Built with Node.js, requiring version 18 or higher.

Tools

  1. read_query

    Execute SELECT queries to read data

  2. write_query

    Execute INSERT, UPDATE, or DELETE queries

  3. create_table

    Create new tables in the database

  4. alter_table

    Modify existing table schema

  5. drop_table

    Remove a table from the database

  6. list_tables

    Get a list of all tables

  7. describe_table

    View schema information for a table

  8. export_query

    Export query results as CSV/JSON

  9. append_insight

    Add a business insight to memo

  10. list_insights

    List all business insights