mapsql-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DATABASE_URL | No | Database connection URL. Use postgresql://readonly:secret@localhost:5432/gis for PostGIS, or oracle://USER:PASS@host:1521/service_name for Oracle Spatial. | |
| MAPSQL_LAYERS | No | Comma-separated table/layer patterns to expose, e.g. schema.table, schema.*, or table. | |
| MAPSQL_BACKEND | No | Force the backend. Valid values are postgis or oracle. Default: detected from the DATABASE_URL scheme, or Oracle when only MAPSQL_ORACLE_DSN is set. | auto |
| MAPSQL_BASEMAP | No | Basemap setting: osm, none, or a tile URL template containing {z}/{x}/{y}. Use none for fully offline operation. Maps rendered with the OSM basemap carry attribution. | osm |
| MAPSQL_SCHEMAS | No | Comma-separated schema allowlist. For Oracle, these are owners. Example: public,osm or GIS. | |
| MAPSQL_MAX_ROWS | No | Hard row cap. The server never materialises a larger result. | 5000 |
| MAPSQL_LOG_LEVEL | No | Log level. Logs go to stderr only. | WARNING |
| MAPSQL_OPEN_MAPS | No | Open each rendered map in the default viewer. Useful for clients that do not display tool images. Equivalent to --open-maps. | off |
| MAPSQL_ORACLE_DSN | No | Oracle DSN / TNS descriptor or Easy Connect string, used as an alternative to DATABASE_URL for Oracle Spatial. The DSN overrides the host part of an oracle:// URL. | |
| MAPSQL_OUTPUT_DIR | No | Directory where render_map saves PNG/HTML output and the tile cache. | ~/mapsql-mcp-output |
| MAPSQL_ALLOW_WRITE | No | Enable the execute_sql tool for writes. PostGIS only. Equivalent to --allow-write. | off |
| MAPSQL_ORACLE_USER | No | Oracle Spatial username. Used with MAPSQL_ORACLE_DSN and MAPSQL_ORACLE_PASSWORD; overrides the user in an oracle:// URL. | |
| MAPSQL_DEFAULT_LIMIT | No | Default limit used when a query does not specify a limit. | 100 |
| MAPSQL_ORACLE_PASSWORD | No | Oracle Spatial password. Used with MAPSQL_ORACLE_DSN and MAPSQL_ORACLE_USER; overrides the password in an oracle:// URL. | |
| MAPSQL_ORACLE_WALLET_DIR | No | Oracle mTLS wallet directory. Only needed for mutual-TLS (wallet) connections, e.g. Autonomous Database with mTLS required. | |
| MAPSQL_STATEMENT_TIMEOUT_MS | No | Per-query timeout in milliseconds. | 15000 |
| MAPSQL_ORACLE_WALLET_PASSWORD | No | Oracle mTLS wallet password. Only needed for mutual-TLS (wallet) connections. |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
This server cannot be deployed
Maintenance
ActivityMaintained
ResponsivenessNo issues