Customable - MCPs

Repositories

49

Projects Packages

17

@customable/db-mcp (1.0.5)

Published 2025-10-07 17:11:49 +02:00 by jack in customable-mcp/db-mcp

Installation

Setup this registry in your project .npmrc file:

@customable:registry=

To install the package using npm, run the following command:

npm install @customable/db-mcp@1.0.5

or add it to the package.json file:

"@customable/db-mcp": "1.0.5"

For more information on the npm registry, see the documentation.

About this package

🗄️ db-mcp

MCP Server for database access supporting PostgreSQL, MariaDB/MySQL, and SQLite.

Features

Query Execution

• 🔍 run_query - Execute SQL query
• 📊 run_query_batch - Execute multiple queries
• 🔐 Uses prepared statements for security

Schema Operations

• 📋 list_tables - List all tables
• 🗂️ get_table_schema - Get table structure
• 📊 get_table_info - Get table statistics (rows, size)
• 🔍 describe_table - Detailed table information

Database Management

• 🗄️ list_databases - List all databases
• 🔄 switch_database - Switch active database
• 📊 get_database_size - Get database size

Advanced Features

• 📈 explain_query - Analyze query performance
• 🔄 Schema diff (compare schemas)
• 📊 Query statistics

Supported Databases

• PostgreSQL 9.6+
• MySQL/MariaDB 5.7+
• SQLite 3.x

Installation

npm install
npm run build

Configuration

Set environment variables based on your database type:

PostgreSQL

export DB_TYPE=postgres
export DB_HOST=localhost
export DB_PORT=5432
export DB_USER=myuser
export DB_PASSWORD=mypassword
export DB_NAME=mydatabase

MySQL/MariaDB

export DB_TYPE=mysql
export DB_HOST=localhost
export DB_PORT=3306
export DB_USER=myuser
export DB_PASSWORD=mypassword
export DB_NAME=mydatabase

SQLite

export DB_TYPE=sqlite
export DB_PATH=/path/to/database.sqlite

Usage

npm start

Security

⚠️ Important:

• Always use prepared statements (automatically done)
• Never expose database credentials in logs
• Use read-only users when possible
• Limit query execution time

License

MIT

Dependencies

Dependencies

ID	Version
@modelcontextprotocol/sdk	^0.5.0
better-sqlite3	^9.4.0
mysql2	^3.9.0
pg	^8.11.0
zod	^3.23.8

Development dependencies

ID	Version
@types/better-sqlite3	^7.6.9
@types/node	^22.0.0
@types/pg	^8.11.0
typescript	^5.5.0

Keywords

mcp database postgresql mysql mariadb sqlite mcp-server

Details

npm

customable-mcp/db-mcp

2025-10-07 17:11:49 +02:00

1

Customable Team

Project website

MIT

11 KiB

Assets (1)

db-mcp-1.0.5.tgz 11 KiB

Versions (2) View all

2.0.0 2025-10-10

1.0.5 2025-10-07

Issues