# Jestor MCP

> Jestor lets your AI client manage complex internal data structures, workflows, and user records. It connects to a low-code API, allowing agents to list available datasets, retrieve specific entries, audit automated processes, and check system permissions for organizational databases.

## Overview
- **Category:** business-operations
- **Price:** Free
- **Tags:** low-code, workflow-automation, database-management, internal-tools, task-management, data-modeling

## Description

Need your agent to interact with proprietary company data? This MCP gives it the ability to act like a skilled internal operations analyst. Instead of manually jumping through dashboards or opening multiple tabs just to pull a single piece of information, your AI client talks directly to Jestor's backend. You can ask it to list all available datasets, then retrieve specific records from those tables, and even audit every automated workflow running in the background. It’s built for organizations that run on internal tools, making data access predictable and repeatable. Connecting through Vinkius means you don't have to manage ten different vendor connections; you just connect once from your preferred agent and get Jestor alongside everything else. This lets your team move past basic queries and actually perform deep database management tasks using simple natural language prompts.

## Tools

### get_me
Verifies your connection status and retrieves details about the currently authenticated user.

### get_object
Retrieves the detailed schema, including field types and relationships for any specific data table.

### get_record
Pulls all details for a single, specified entry or record in your database.

### list_apps
Provides a list of every installed internal application available to the user.

### list_dashboards
Lists all configured data visualization dashboards within the system.

### list_objects
Returns a comprehensive list of every available dataset or object name in your account.

### list_records
Lists all records belonging to a specific data table, allowing for browsing an entire dataset.

### list_users
Retrieves names, emails, and unique IDs for every user in the organization's directory.

### list_webhooks
Lists all external integrations configured via webhooks, useful for auditing third-party connections.

### list_workflows
Retrieves a list of all automated workflows and event-driven business logic running in the background.

## Prompt Examples

**Prompt:** 
```
List all objects in my Jestor account.
```

**Response:** 
```
I'll fetch the list of all tables and objects for you.
```

**Prompt:** 
```
Show me the records for the 'Invoices' object.
```

**Response:** 
```
I'll retrieve the records from your Invoices table in Jestor.
```

**Prompt:** 
```
Check the status of my workflows.
```

**Response:** 
```
I'll look up the list of configured workflows and their status in Jestor.
```

## Capabilities

### Identify available datasets
List all the data tables (objects) in the system so you know what information exists.

### Inspect data structure details
Get a schema for any object, telling you exactly what fields and relationships are available in that table.

### Fetch specific records by ID
Deep-dive into a single record or entry within any monitored dataset.

### Audit system processes
List and check the status of automated workflows, installed applications, and configured webhooks.

## Use Cases

### Investigating a data discrepancy
A business analyst notices a client record is wrong. Instead of emailing three different department heads, they ask their agent to run `get_object` first. This verifies the schema, then they use `get_record` to pull the actual data and see exactly which fields are populated.

### Onboarding a new team member
The system admin needs to verify who has access to sensitive client lists. They ask their agent to run `list_users` and then use `get_me` to confirm the scope of the current user's permissions, ensuring proper role assignment.

### Debugging an automated process failure
A data ops engineer finds that a nightly report failed. They instruct their agent to run `list_workflows` to see which processes are scheduled, and then use `list_webhooks` to check if the necessary external connection points are still active.

### Understanding application scope
A consultant needs a full picture of the platform. They ask their agent to run `list_apps` and `list_dashboards`. This gives them an immediate, comprehensive view of everything installed and visible to the end-user.

## Benefits

- You instantly know what data you can access. Instead of guessing where information lives, your agent calls `list_objects` to get a definitive list of all available datasets.
- Audit your system logic without clicking around. Use `list_workflows` or `list_webhooks` to see exactly which automated processes are running and how they connect to external tools.
- Get full context on data structures before querying. The `get_object` tool tells you the schema, so you know if a field is a date or text *before* your agent tries to read it.
- Eliminate repetitive lookups for people. If you need to check who owns a record or find an employee's details, running `list_users` gives that data immediately.
- Move beyond simple querying into deep auditing. You can retrieve specific records using `get_record`, and then cross-reference the owner ID against the user list via `list_users`.

## How It Works

The bottom line is that your agent treats your internal database like a structured API endpoint, allowing for precise, targeted data retrieval without manual UI interaction.

1. Your agent first uses `get_me` to confirm its connection status and view current user permissions.
2. It then uses `list_objects` to generate a catalog of all available data tables, guiding the next action.
3. Finally, it runs `list_records` or `get_record`, passing in the specific object name and necessary parameters to pull the required data.

## Frequently Asked Questions

**How do I find out what data tables are available using Jestor MCP?**
Run `list_objects`. This tool immediately returns a comprehensive list of every object or dataset name in your account, giving you a clear scope.

**Can Jestor MCP help me audit my automated systems?**
Yes. You can use `list_workflows` to see all running processes and `list_webhooks` to check which external services are connected or configured for event triggers.

**What is the difference between getting a record and listing records with Jestor MCP?**
Use `get_record` when you know the specific ID of one item (like Client #123) and need its full details. Use `list_records` when you want to browse or see multiple items from an entire dataset.

**Does Jestor MCP tell me what fields are in a table?**
Yes, use the `get_object` tool. This fetches the detailed schema for any object, showing you every field name and its data type (text, date, number).

**How do I check user permissions with Jestor MCP?**
The `get_me` tool verifies your connection status and provides details about the currently authenticated user's profile and access rights.