mcp-database
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DB_HOST | Yes | The database host (e.g., localhost) | |
| DB_NAME | Yes | The database name | |
| DB_PORT | No | The database port (default: 3306) | 3306 |
| DB_USER | Yes | The database user (e.g., readonly_user) | |
| MAX_ROWS | No | Maximum rows returned per query (default: 1000) | 1000 |
| DB_PASSWORD | Yes | The database password | |
| QUERY_TIMEOUT_MS | No | Query timeout in milliseconds (default: 15000) | 15000 |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_tablesA | Tampilkan daftar semua tabel di database. Gunakan ini lebih dulu untuk tahu tabel apa saja yang tersedia sebelum membuat query. |
| describe_tableA | Tampilkan struktur (kolom, tipe data, nullable, key) dari sebuah tabel. Gunakan untuk memahami skema sebelum menulis SELECT. |
| run_queryA | Jalankan query SQL read-only (SELECT/SHOW/DESCRIBE/EXPLAIN/WITH) untuk pengecekan data. Perintah tulis (INSERT/UPDATE/DELETE/DROP/dll) akan ditolak. Hasil dibatasi maksimal 1000 baris. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/AimanFadillah/mcp-database'
If you have feedback or need assistance with the MCP directory API, please join our Discord server