Frappe Assistant Core v2.3.0

[buildswithpaul]

Frappe Assistant Core v2.3.0

Highlights

Prompt Templates System - This release introduces a major new feature: database-driven prompt templates with full MCP protocol support. Domain experts can now create reusable, parameterized prompts that users can customize and execute via AI clients.

---

Major Feature - Prompt Templates System

MCP Prompts Support

FAC now supports the MCP prompts/list and prompts/get protocol methods, enabling "Prompt Engineering as a Service":

• Full MCP prompts protocol support (prompts/list, prompts/get)
• Database-driven prompt templates replacing hardcoded prompts
• Template rendering with Jinja2, Format String, and Raw engines
• Usage analytics tracking (use_count, last_used)

New DocTypes

DocType	Purpose
Prompt Template	Main template with content, arguments, and metadata
Prompt Template Argument	Child table defining configurable parameters
Prompt Category	Hierarchical tree structure for organization

Features

• Template Content: Jinja2 templates with {{ placeholders }} for dynamic content
• Configurable Arguments: Define parameters with types (string, number, boolean, select, multiselect)
• Argument Validation: Required fields, regex patterns, allowed values, min/max length
• Default Values: Pre-populate optional arguments
• Live Preview: Test template rendering before publishing

Access Control & Sharing

• Visibility Levels: Private (owner only), Shared (specific roles), Public (all users)
• Role-Based Sharing: Share prompts with specific Frappe roles
• System Templates: Protected templates installed via migration (cannot be deleted)
• Permission Filtering: MCP returns only prompts accessible to current user

Versioning & History

• Automatic version number increment on significant changes
• Full change history using Frappe's track_changes
• Rollback to any previous version
• Duplicate system/public templates for customization

Pre-built System Templates

• manufacturing_analysis - Manufacturing & production analysis
• sales_analysis - Sales performance and trends
• purchase_analysis - Procurement and supplier analysis
• hr_analysis - HR metrics and workforce analysis
• crm_analysis - Customer relationship analysis
• doctype_documentation - DocType documentation generator
• data_quality_audit - Data quality and integrity audits

---

Bug Fixes

OAuth Token Timezone Fix (#83)

• Fixed timezone mismatch in OAuth token expiration validation
• Changed from datetime.datetime.now() to Frappe's now_datetime() for timezone-aware comparisons
• Users in non-UTC timezones no longer experience premature token expiration

CI/CD Pipeline Fixes

• Fixed CI failing due to Python version incompatibility with Frappe 16 dev branch
• Changed bench init to explicitly use --frappe-branch version-15 for stable builds
• Upgraded CI Python version from 3.10 to 3.12

Code Quality - cur_frm Deprecation Fixes

• Fixed semgrep frappe-cur-frm-usage violations in prompt_template.js
• Replaced deprecated cur_frm usage with proper Frappe patterns

---

UI/UX Improvements

Dark Theme Support

• FAC Admin Page: Fixed MCP Endpoint URL visibility, toggle switches, tool badges, and table cells
• Assistant Core Settings: Updated alert boxes, plugin cards, form controls, and search inputs to use CSS variables

---

Documentation

• Added comprehensive Prompt Templates User Guide
• Updated MCP StreamableHTTP Guide with timezone-aware token validation example
• Updated Technical Documentation with correct now_datetime() usage

---

Migration Notes

After upgrading to v2.3.0, run:

bench --site your-site migrate

This will install:

• System prompt categories
• System prompt templates
• Required database schema changes

---

Full Changelog

See CHANGELOG.md for complete details.

---

Contributors: @buildswithpaul

New Contributors

@Alababdiy made their first contribution in #84

Full Changelog: v2.2.2...v2.3.0

---

This discussion was created from the release Frappe Assistant Core v2.3.0.