ServiceNow Pocket Admin

Talk to ServiceNow and avoid a divorce.

Put an admin in the development loop.

Just ask.

Creating test data on the fly

"Create incidents with random priorities and assign them to the Service Desk group"

Understanding an instance you just inherited

"What tables have been modified in the last 30 days?"

Running a security audit

"Which users have not logged in for over 90 days?"

Extracting data without pagination headaches

"Export all incidents opened this year with their assignment groups and resolution notes"

Building reports without the report builder

"Average resolution time for P1 incidents this quarter"

Exploring the data model

"What tables are related to cmdb_ci?"

How it works

There's a built-in SQL engine under the hood. Relax, you won't need to learn SQL. Life is too short for that too.

You talk in your own language. Pocket Admin does the rest.

Nothing to install on your instance. Everything goes through ServiceNow's official APIs, so your business rules, ACLs, and quotas are safe and sound. No tricks. No surprises. No GlideRecord.

Not ready to bring AI into the picture? You can use the extension on your own without spending a cent. The catch? We give you the tools, but now you are the admin.

Quick Start

Install the extension, configure your ServiceNow connection, download the tables, add the MCP server to Claude, and finally enjoy talking to ServiceNow. Five minutes. That's it.

Prerequisites: Your ServiceNow instance needs OAuth2 configured (password grant), and the user account needs read access to sys_db_object (for tables) and sys_dictionary (for columns).

Here's how:

1. Install the extension from the VS Code Marketplace
2. Open the Command Palette (Ctrl+Shift+P) and run Pocket Admin: Configure Connection
3. Enter your ServiceNow instance URL, OAuth Client ID, Client Secret, username, and password
4. Run Pocket Admin: Refresh Tables Cache to download your instance's table metadata
5. Run Pocket Admin: Copy MCP Config for Claude and paste it into your Claude Code MCP config (~/.mcp.json)
6. Start talking to your instance through Claude

Settings: You can change the maximum number of rows returned per query in VS Code settings: sql-servicenow.maxResults (default: 10,000).

SQL Engine

But if you are the kind of developer who enjoys wrestling with SQL, we've got you covered. Open a .sql or .snsql file, write your queries with autocomplete (Ctrl+Space) and syntax highlighting, run them with Ctrl+Shift+E, filter results, and export to CSV. All yours.

-- List open incidents
SELECT number, short_description, priority
FROM incident
WHERE active = true
LIMIT 10

-- Who's got the most incidents?
SELECT u.user_name, COUNT(*) as total
FROM incident i
JOIN sys_user u ON i.assigned_to = u.sys_id
GROUP BY u.user_name
ORDER BY total DESC

-- Resolve choice labels (yes, it handles sys_choice joins)
SELECT i.sys_id, c.label
FROM incident i
JOIN sys_choice c ON c.value = CAST(i.priority AS STRING)
  AND c.element = 'priority'
  AND c.language = 'en'
  AND c.name = 'task'
WHERE i.resolved_at > STARTOFYEAR(-5)
  AND i.priority IN (3, 4, 5)

-- Explore your data model
SHOW TABLES LIKE '%incident%'
SHOW COLUMNS FROM incident

Feedback

Found a bug? Have an idea? Open an issue and let us know.

Who's behind this?

KintoSoft. Saving marriages between developers and ServiceNow since 2025.