home / mcp / servicenow mcp server

ServiceNow MCP Server

This read-only MCP Server allows you to connect to ServiceNow data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-servicenow-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/servicenow.prp"
      ]
    }
  }
}

You will run a local, read‑only MCP server that exposes ServiceNow data via a simple MCP interface. This lets you ask natural language questions and retrieve live ServiceNow information without writing SQL, while keeping access to your data controlled and centralized on your machine.

How to use

When you have the MCP server running, you can interact with it through an MCP client. You do not need to write SQL queries; instead, you ask the AI to read data from ServiceNow and answer questions based on the available tables and columns. The server exposes a set of read operations that let the AI discover what data is available, fetch specific columns, and run queries to retrieve results. Use natural language prompts like: - What is the current status of opened incidents for the SUPPORT project? - Which accounts have a priority higher than P1 and are in the West region? - Show me the latest changes to the Change Records table.

How to install

# Prerequisites
- Java Runtime Environment (JRE) or JDK
- Maven for building the MCP server
- Access to the ServiceNow data via the CData JDBC Driver for ServiceNow

# 1) Build the MCP server
git clone https://github.com/cdatasoftware/servicenow-mcp-server-by-cdata.git
cd servicenow-mcp-server-by-cdata
mvn clean install
# This produces CDataMCP-jar-with-dependencies.jar

# 2) Install the CData JDBC Driver for ServiceNow
# Follow the driver's installation steps from the official download page and license it as shown below.

Additional notes

The MCP server is designed to be used locally. It runs via a standard Java command and uses a .prp file to configure the JDBC connection. You will create a servicenow.prp file with your driver path, JDBC URL, and any tables you want to expose. Then you start the MCP server with that .prp file.

Troubleshooting

If you cannot see the MCP server in your client, ensure you fully quit and restart the client so it reloads the available servers. If data cannot be retrieved, verify your connection string and the .prp file contents, then test the connection using the provided connection string utility. If issues persist, contact CData Support or join the CData Community for help.

License

This MCP server is available under the MIT License. You may use, modify, and distribute it in accordance with the license terms.

Available tools

servicenow_get_tables

Retrieves a list of available tables from the ServiceNow data source. The output is a CSV with the first line as column headers.

servicenow_get_columns

Retrieves a list of columns for a specified table. The output is a CSV with column headers on the first line.

servicenow_run_query

Executes a SQL SELECT query against the exposed tables within ServiceNow via the MCP server.