FairCom MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| FAIRCOM_API_TOKEN | No | Alternative to username/password: API token for authentication | |
| FAIRCOM_HTTP_HOST | No | Host address for the MCP server to bind to | 0.0.0.0 |
| FAIRCOM_HTTP_PORT | No | Port for the MCP server | 8000 |
| FAIRCOM_TLS_VERIFY | No | Whether to verify TLS certificates (set to 'false' for self-signed certs) | true |
| FAIRCOM_API_BASE_URL | Yes | Required: The base URL of the FairCom JSON API, e.g. https://faircom.example.com:9443 | |
| FAIRCOM_API_PASSWORD | No | Password for FairCom database authentication (use with FAIRCOM_API_USERNAME) | |
| FAIRCOM_API_USERNAME | No | Username for FairCom database authentication (use with FAIRCOM_API_PASSWORD) | |
| FAIRCOM_SQL_DENYLIST | No | Comma-separated list of denied SQL statements | DROP,TRUNCATE,ALTER |
| FAIRCOM_SQL_ALLOWLIST | No | Comma-separated list of allowed SQL statements | SELECT,INSERT,UPDATE,DELETE |
| FAIRCOM_TOOL_GROUP_ALLOWLIST | No | Comma-separated list of allowed tool groups | metadata,query,write,admin,diagnostics |
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
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| logging | {} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| extensions | {
"io.modelcontextprotocol/ui": {}
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_tablesC | List database tables, optionally filtered by a name pattern. |
| describe_tableB | Describe a table's columns and metadata by name. |
| list_table_columnsC | List the columns defined on a table, including integration tables. |
| list_table_indexesC | List the indexes defined on a table. |
| list_inputsA | List the names of previously created input connectors. |
| describe_inputsA | Describe one or more input connectors by name (payload.inputNames is required; call list_inputs first to discover names). |
| list_servicesA | List FairCom services and their runtime state (enabled/running/disabled). |
| manage_serviceB | Pause, resume, restart, shut down, or start up a FairCom service. |
| create_inputC | Create a new input connector that collects data from a device or software system. |
| alter_inputC | Modify settings on an existing input connector. |
| delete_inputC | Delete an input connector definition. |
| list_outputsC | List the names of previously created output connectors. |
| describe_outputsB | Describe one or more output connectors by name. |
| create_outputB | Create a new output connector that delivers collected data to an external service. |
| alter_outputC | Modify settings on an existing output connector. |
| delete_outputC | Delete an output connector definition. |
| list_integration_tablesC | List integration tables in a database. |
| describe_integration_tablesC | Describe one or more integration tables, including fields and transform steps. |
| create_integration_tableB | Create an integration table, optionally with fields and transform steps. |
| alter_integration_tableB | Alter an integration table's fields, transform steps, or retention policy. |
| delete_integration_tablesC | Delete one or more integration tables. |
| test_integration_table_transform_stepsB | Test an integration table's transform steps against records before applying them for real. |
| list_topicsA | List the names of MQTT topics the server is tracking. |
| describe_topicsB | Describe one or more MQTT topics by name. |
| configure_topicC | Create or update an MQTT topic and bind it to an integration table. |
| delete_topicC | Delete an MQTT topic. |
| sql_queryB | Run a read-only SQL query against a FairCom database. |
| sql_query_pageB | Run a read-only SQL query and return one page of results at a time. |
| get_usage_contractA | Return this server's tool usage contract: argument aliases, canonical arg names, and payload examples. |
| describe_connector_schemaC | Describe the expected input or output connector payload schema for a service. |
| validate_connector_payloadsA | Validate one or more connector payloads locally without writing to FairCom. |
| list_code_packagesC | List registered code packages. |
| describe_code_packagesC | Describe one or more code packages by name. |
| register_code_packageC | Create or update a JavaScript code package, such as an integration table transform. |
| clone_code_packageB | Clone an existing code package under a new name. |
| revert_code_packageC | Revert a code package to a prior version. |
| runtime_statusA | Report this MCP server's own runtime and configuration status. |
| capabilities_summaryA | Summarize the tools this MCP server exposes and their write-safety model. |
| observability_metricsB | Return this MCP server's own operational metrics. |
| observability_auditA | Return recent audit log entries for write operations performed through this server. |
| observability_healthB | Return this MCP server's health status. |
| sql_executeB | Execute a write SQL statement (insert/update/delete) against FairCom. |
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
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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/toddstoffel/faircom-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server