Frappe_Assistant_Core

Overview

Frappe Assistant Core is an MCP server that bridges language models with ERPNext, exposing 24 built-in tools for document CRUD operations, search capabilities, report generation, workflow management, analytics, and dashboards. The server uses OAuth 2.0 for authentication, ensuring LLMs operate within user permissions and all interactions are logged. It allows customization through Skills and Prompt Templates, which can be extended by developers through hooks in Frappe apps.

Try asking AI

After installing, here are 6 things you can ask your AI assistant:

• get_document

  Retrieve a specific document from ERPNext

  Try:Get invoice INV-2023-001Try:Fetch customer John Doe's details
• list_documents

  List documents matching criteria

  Try:List all customersTry:Show me all invoices from this month
• create_document

  Create a new document in ERPNext

  Try:Create a new customerTry:Add a new sales order
• update_document

  Update an existing document

  Try:Update customer John Doe's emailTry:Change invoice status to Paid
• delete_document

  Delete a document from ERPNext

  Try:Delete cancelled invoice INV-2023-005Try:Remove old lead records
• submit_document

  Submit a document for workflow

  Try:Submit the expense report for approvalTry:Submit sales order
• search

  Search across ERPNext data

  Try:Search for product SKU-1234Try:Find customers in New York
• generate_report

  Generate business reports

  Try:Generate monthly sales reportTry:Show revenue by region
• run_python_code

  Execute Python code for custom analytics

  Try:Calculate average customer lifetime valueTry:Analyze sales trends
• extract_file_content

  Extract text from uploaded files

  Try:Extract text from invoice.pdfTry:Read data from spreadsheet.xlsx
• create_dashboard

  Create a custom dashboard

  Try:Create sales dashboardTry:Build inventory tracking dashboard
• analyze_business_data

  Analyze business data with ML

  Try:Analyze customer churn patternsTry:Forecast next quarter's sales

Comparable tools

Installation

cd frappe-bench
bench get-app https://github.com/buildswithpaul/Frappe_Assistant_Core
bench --site <your-site> install-app frappe_assistant_core

FAQ

What authentication method does FAC use?

FAC uses OAuth 2.0 with PKCE for LLM connections, ensuring the LLM never sees the user's Frappe password.

Can I extend FAC with my own tools?

Yes, developers can add custom tools through the `assistant_tools` hook in their Frappe app's `hooks.py` file.

How does FAC handle data permissions?

Every tool call is scoped to the calling user's Frappe and ERPNext roles and permissions, maintaining consistent access controls.

Compare Frappe_Assistant_Core with