Skip to main content
Glama
MCP Art Supply Store

MCP Art Supply Store

by wspotter

šŸŽØ MCP Art Supply Store

Model Context Protocol Server with 36 Business Management Tools

TypeScript MCP Node.js

A complete Model Context Protocol (MCP) server for managing an art supply store business with 36 professional tools across 8 categories, plus social media integration.

✨ Features

šŸ“¦ 36 Business Management Tools

šŸ›ļø Inventory Management (5 tools)

  • Add/update/remove products

  • Check stock levels

  • Low stock alerts

  • Track product details

šŸ‘„ Customer Management (4 tools)

  • Add/update/retrieve customers

  • Customer purchase history

  • Loyalty tracking

  • Contact management

šŸ“ Order Processing (5 tools)

  • Create/update/cancel orders

  • Order status tracking

  • Order history

  • Fulfillment management

šŸ’° Financial Tools (3 tools)

  • Sales reports

  • Revenue tracking

  • Profit analysis

šŸŽØ Art Classes (5 tools)

  • Schedule management

  • Student enrollment

  • Instructor tracking

  • Class capacity monitoring

šŸ“Š Analytics (4 tools)

  • Sales analytics

  • Customer insights

  • Product performance

  • Trend analysis

šŸ“¢ Marketing (3 tools)

  • Campaign management

  • Promotion tracking

  • Customer targeting

🌐 Social Media (12 tools)

  • Facebook post creation

  • Instagram publishing

  • Post scheduling

  • Comment management

  • Analytics tracking

  • Multi-platform support

šŸŽÆ Key Capabilities

  • Complete Business Management - All tools for running an art supply store

  • Social Media Integration - Facebook & Instagram via Meta Graph API (FREE)

  • Real-time Analytics - Track sales, customers, and performance

  • Web Dashboard - Beautiful UI for testing and monitoring

  • TypeScript - Type-safe, maintainable code

  • MCP Protocol - Standard Model Context Protocol implementation

šŸš€ Quick Start

Prerequisites

  • Node.js 18+

  • npm or yarn

  • (Optional) Facebook/Instagram Business accounts for social media features

Installation

# Clone the repository
git clone https://github.com/wspotter/mcpart.git
cd mcpart

# Install dependencies
npm install

# Build the project
npm run build

# Configure environment (optional - for social media)
cp .env.example .env
# Edit .env with your API keys

Running the Server

As MCP Server:

npm start

With Dashboard:

npm run dashboard
# Open http://localhost:3000

šŸ“– Documentation

Total: 1,500+ lines of documentation

šŸ› ļø Tool Categories

1. Inventory Management

inventory_add_product
inventory_update_product
inventory_remove_product
inventory_check_stock
inventory_list_low_stock

2. Customer Management

customer_add
customer_update
customer_get
customer_list_purchases

3. Order Processing

order_create
order_update
order_cancel
order_get_status
order_list

4. Financial Tools

finance_get_sales_report
finance_get_revenue
finance_get_profit_analysis

5. Art Classes

class_schedule
class_enroll_student
class_list_students
class_get_schedule
class_update_instructor

6. Analytics

analytics_sales_trends
analytics_customer_insights
analytics_product_performance
analytics_monthly_report

7. Marketing

marketing_create_campaign
marketing_track_promotion
marketing_get_customer_segments

8. Social Media (Meta Graph API - FREE!)

social_facebook_create_post
social_instagram_create_post
social_schedule_post
social_get_post_analytics
social_reply_to_comment
social_get_comments
social_delete_post
social_update_post
social_get_page_insights
social_get_instagram_insights
social_upload_media
social_get_scheduled_posts

šŸŽØ Dashboard

Beautiful web interface for testing and monitoring:

Features

  • 8 Category Navigation - Organized sidebar

  • Tool Cards - Visual tool display with descriptions

  • Real-time Testing - Test any tool with JSON input

  • Search Functionality - Find tools quickly

  • Responsive Design - Works on all devices

  • Dark Theme - Easy on the eyes

Access

npm run dashboard
open http://localhost:3000

🌐 Social Media Integration

Facebook & Instagram (FREE!)

Uses Meta Graph API - no cost for basic posting and analytics.

Setup Steps:

  1. Create Facebook App

  2. Get Page Access Token

  3. Configure .env file

  4. Connect Instagram Business Account

  5. Start posting!

See: FACEBOOK_INSTAGRAM_SETUP.md for detailed guide (500+ lines)

Features:

  • Create posts with images

  • Schedule future posts

  • Monitor comments

  • Reply to comments

  • Track analytics

  • Multi-platform (FB + IG)

šŸ“Š Example Usage

Add a Product

{
  "name": "inventory_add_product",
  "arguments": {
    "name": "Acrylic Paint Set",
    "sku": "APS-001",
    "quantity": 50,
    "price": 29.99,
    "category": "Paint",
    "supplier": "ArtPro Inc"
  }
}

Create Facebook Post

{
  "name": "social_facebook_create_post",
  "arguments": {
    "message": "New paint sets just arrived! šŸŽØ",
    "imageUrl": "https://example.com/paint.jpg",
    "link": "https://shop.example.com/paint-sets"
  }
}

Check Sales Report

{
  "name": "finance_get_sales_report",
  "arguments": {
    "startDate": "2025-10-01",
    "endDate": "2025-10-31"
  }
}

šŸ”§ Configuration

Environment Variables

# .env file

# Server
PORT=3000

# Meta Graph API (for social media - optional)
META_ACCESS_TOKEN=your_page_access_token
META_PAGE_ID=your_facebook_page_id
META_INSTAGRAM_ACCOUNT_ID=your_instagram_business_account_id

# API Version
META_API_VERSION=v18.0

MCP Configuration

Add to your MCP client config (e.g., Claude Desktop):

{
  "mcpServers": {
    "art-supply-store": {
      "command": "node",
      "args": ["/path/to/mcpart/build/index.js"],
      "env": {
        "META_ACCESS_TOKEN": "your_token_here"
      }
    }
  }
}

šŸ“ Project Structure

mcpart/
ā”œā”€ā”€ src/
│   ā”œā”€ā”€ index.ts              # Main MCP server
│   ā”œā”€ā”€ dashboard.ts          # Web dashboard server
│   └── social-media.ts       # Social media manager
ā”œā”€ā”€ public/
│   ā”œā”€ā”€ index.html            # Dashboard UI
│   ā”œā”€ā”€ styles.css            # Dashboard styling
│   └── script.js             # Dashboard logic
ā”œā”€ā”€ build/                    # Compiled TypeScript
ā”œā”€ā”€ docs/
│   ā”œā”€ā”€ TOOLS_DOCUMENTATION.md
│   ā”œā”€ā”€ FACEBOOK_INSTAGRAM_SETUP.md
│   └── QUICK_REFERENCE.md
ā”œā”€ā”€ .env.example              # Environment template
ā”œā”€ā”€ package.json
ā”œā”€ā”€ tsconfig.json
└── README.md

šŸŽÆ Use Cases

  • Art Supply Stores - Complete business management

  • Retail Shops - Inventory and sales tracking

  • Class Management - Schedule and enrollment

  • Social Media Marketing - Automated posting

  • Business Analytics - Performance tracking

  • Customer Management - Loyalty and history

  • AI Assistants - Give AI tools to manage business

šŸ¤ Contributing

Contributions welcome! Areas for improvement:

  • Additional payment integrations

  • Email marketing tools

  • Advanced analytics dashboards

  • Mobile app

  • More social platforms (Twitter, TikTok)

  • Inventory forecasting

  • CRM features

šŸ“„ License

MIT License - free to use in your projects!

šŸ™ Credits

Built with:

  • MCP TypeScript SDK - @modelcontextprotocol/sdk

  • Meta Graph API - Facebook/Instagram integration

  • Express.js - Dashboard server

  • TypeScript - Type-safe development

🌟 Star This Repo!

If you find this MCP server useful, please give it a ⭐!

šŸ“ž Support

šŸ”® Roadmap

  • 24 core business tools

  • Social media integration (12 tools)

  • Web dashboard

  • TypeScript implementation

  • Meta Graph API integration

  • Additional social platforms

  • Email marketing

  • Advanced analytics

  • Mobile app

  • Multi-store support

šŸ“ˆ Stats

  • 36 Tools across 8 categories

  • 1,500+ lines of documentation

  • TypeScript for type safety

  • Free social media posting

  • Production-ready code

  • Comprehensive error handling

šŸ’¼ Perfect For

  • Small business owners

  • Art supply stores

  • Retail shops

  • AI assistant developers

  • MCP protocol developers

  • Social media managers

šŸŽ‰ Get Started

git clone https://github.com/wspotter/mcpart.git
cd mcpart
npm install
npm run build
npm run dashboard
# Visit http://localhost:3000

Version: 1.0
Tools: 36 professional tools
Status: Production-Ready
Created: October 2025

Made with šŸ’š for the MCP community!

Transform your AI assistant into a complete business management system! šŸŽØ

Available Tools

36 tools
analyze_post_performanceC

Analyze individual post performance with insights on what content performs best.

Inputs: postId (required), compareToAverage.

auto_respond_common_questionsC

Enable automatic responses to frequently asked questions (hours, location, stock availability).

Inputs: enable (required), questionTypes.

book_appointmentC

Schedule a new appointment for custom framing, consultations, or workshops.

Inputs: customerName (required), date (required), service (required), time (required).

calculate_discountB

Calculate discounted price for promotions, bulk orders, or loyalty rewards.

Inputs: discountType (required), discountValue (required), sku (required), quantity.

calculate_labor_costC

Calculate labor costs for a specific period based on employee hours and rates.

Inputs: endDate (required), startDate (required).

calculate_profit_marginC

Calculate profit margin for a product or category based on cost and selling price.

Inputs: costPrice (required), sku (required).

check_appointmentsC

Check scheduled appointments for a specific date or customer.

Inputs: date.

check_inventoryB

Check current inventory levels for a specific product or category. Returns stock quantity, reorder status, and supplier information.

Inputs: search (required).

compare_supplier_pricesC

Compare prices and terms across suppliers for a specific product or category.

Inputs: productName (required).

create_product_campaignC

Create a multi-post campaign to promote a specific product or collection across platforms.

Inputs: duration (required), platforms (required), productSku (required).

create_purchase_orderA

Create a purchase order for restocking. Automatically suggests items below reorder level.

Inputs: supplier (required), autoIncludeLowStock, customItems.

forecast_demandB

Forecast product demand based on historical sales data and seasonal trends.

Inputs: period (required), sku (required).

generate_eod_reportC

Generate end-of-day report with sales summary, cash reconciliation needs, and action items.

Inputs: date.

generate_hashtagsC

Generate relevant hashtags for posts to maximize reach and engagement.

Inputs: postTopic (required), count, includeLocation.

generate_post_ideasB

Generate creative post ideas based on products, themes, or seasons. Perfect for content planning.

Inputs: products (required), theme (required), count.

get_best_sellersB

Get top-selling products by category or overall, with quantity sold and revenue generated.

Inputs: period (required), category.

get_customer_recommendationsC

Get personalized product recommendations based on customer purchase history and preferences.

Inputs: customerId (required).

get_daily_salesB

Get sales summary for a specific date including revenue, transaction count, and top-selling items.

Inputs: date.

get_employee_scheduleC

Get employee schedule and shift information for staffing planning.

Inputs: date.

get_instagram_story_ideasB

Get creative Instagram Story ideas featuring products, behind-the-scenes, or promotions.

Inputs: occasion (required), products.

get_inventory_valueB

Calculate total inventory value at cost or retail price for financial reporting.

Inputs: valueType (required), category.

get_low_stock_itemsC

Get a list of all items that are at or below their reorder level. Critical for preventing stockouts.

Inputs: category.

get_new_commentsB

Retrieve new comments from Facebook and Instagram posts for timely responses.

Inputs: platform, sinceHours.

get_sales_reportC

Generate comprehensive sales report for a date range with trends, comparisons, and insights.

Inputs: endDate (required), startDate (required).

get_social_analyticsB

Get performance analytics from Facebook and Instagram including reach, engagement, and top posts.

Inputs: platform (required), period.

get_supplier_infoC

Get detailed supplier information including contact details, lead times, and minimum order requirements.

Inputs: supplierName (required).

get_top_customersB

Get list of top customers by total spending or loyalty points. Useful for VIP outreach and marketing.

Inputs: sortBy (required), limit.

lookup_customerB

Find customer information by name, email, or phone. Returns purchase history, loyalty points, and preferences.

Inputs: identifier (required).

post_to_social_mediaA

Post content to Facebook and/or Instagram. Requires Meta API configuration. Can schedule posts for future publishing.

Inputs: message (required), platforms (required), hashtags, imageUrl, +1 more.

schedule_weekly_postsC

Create a weekly posting schedule with varied content types. Saves hours of planning time.

Inputs: postsPerDay (required), startDate (required), focusProducts.

search_productsC

Search for products by name, category, or supplier. Returns detailed product information.

Inputs: query (required), filterBy.

suggest_bundleC

Suggest product bundles based on frequently bought together items or complementary products.

Inputs: baseSku (required).

suggest_comment_replyC

Get AI-powered reply suggestions for customer comments. Maintains friendly, professional tone.

Inputs: commentText (required), tone.

track_competitor_activityC

Track competitor social media activity to stay informed about market trends and pricing.

Inputs: competitors (required), metrics.

update_loyalty_pointsA

Add or redeem loyalty points for a customer. Store policy: 1 point per $1 spent, 100 points = $10 off.

Inputs: customerId (required), points (required), reason (required).

update_stockB

Update inventory quantity after receiving shipment or doing physical count. Records the change in the system.

Inputs: quantity (required), reason (required), sku (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.1/5.0

    Scored across 36 tools

    Disambiguation3/5

    The tools cover distinct functions like inventory, sales, social media, and customer management, but there is notable overlap in areas like social media analytics (analyze_post_performance, get_social_analytics) and reporting (generate_eod_report, get_sales_report), which could cause confusion. Most tools have clear purposes, but the redundancy in some domains reduces clarity.

    Naming Consistency4/5

    The naming follows a consistent verb_noun pattern throughout (e.g., check_inventory, calculate_discount, generate_post_ideas), with only minor deviations like 'auto_respond_common_questions' using a verb_verb_noun structure. Overall, the naming is predictable and readable, supporting easy tool identification.

    Tool Count2/5

    With 36 tools, the count is excessive for an art supply store server, leading to potential overwhelm and inefficiency. A more focused set of 10-20 tools would better cover the domain without unnecessary complexity, as many tools could be consolidated or omitted for a cleaner interface.

    Completeness5/5

    The tool set provides comprehensive coverage for an art supply store, including inventory management, sales tracking, customer relations, social media marketing, and financial operations. It supports full CRUD-like workflows (e.g., check_inventory, update_stock, create_purchase_order) and addresses key business needs without obvious gaps, ensuring agents can handle typical tasks effectively.

    Related MCP Connectors