PRD-20: MCP Server Library & Credential Integration - The 400+ Integration Explosion

Status: Active Development Priority: P0 - CRITICAL Platform Differentiator Effort: Phase 1: 8-12 hours | Phase 2: 20-30 hours Dependencies: PRD-17 (Dynamic Tool Assignment), PRD-18 (Credential Management)


Executive Summary

Transform Automatos AI from a platform with a few tools to the most comprehensive AI orchestration platform with 400+ pre-integrated MCP servers, each perfectly linked to credentials. This creates a Netflix-style marketplace where users enable integrations by simply adding credentials.

The Vision: "One Credential Away from Any Integration"

User adds AWS credentials → 15 AWS MCP servers instantly available User adds GitHub token → 8 GitHub MCP servers enabled User adds Slack token → 6 Slack MCP servers ready Total: 400+ integrations, zero configuration

Current State → Target State

Aspect
Current
After Phase 1
After Phase 2

Credential Types

30

30

400+

MCP Servers

8 manual

30 pre-loaded

400+ pre-loaded

Auto-Activation

Manual

✅ Working

✅ Working

UI Pagination

No

✅ Yes

✅ Yes

Credential Linking

Partial

✅ Complete

✅ Complete

Search/Filter

Basic

✅ Enhanced

✅ Enhanced


Part 1: Two-Phase Strategy

Phase 1: Proof of Concept (30 Servers) - THIS WEEK ✅

Goal: Prove the system works end-to-end with 30 MCP servers

Tasks:

  1. ✅ Create 30 MCP server metadata (matching 30 credential types)

  2. ✅ Implement credential-based auto-activation

  3. ✅ Add pagination to Tools & Settings pages

  4. ✅ Test complete flow: Add credential → Enable MCP server → Assign to agent → Execute

  5. ✅ Verify performance with 30 items

  6. ✅ Fix any bugs or UX issues

Success Criteria:

Deliverables:

  • mcp_servers_library_30.json - 30 MCP server definitions

  • load_mcp_servers.py - Script to bulk-load MCP servers

  • Pagination for Tools page

  • Pagination for Credentials page

  • Enhanced search/filter UI

  • Complete test results

Timeline: 8-12 hours (1-2 days)


Phase 2: Full Integration (400+ Servers) - NEXT WEEK 🚀

Goal: Clone ALL 400+ credential types and MCP servers from n8n

Tasks:

  1. ⏳ Scrape/clone n8n GitHub credentials directory

  2. ⏳ Convert all 400+ credential types to our format

  3. ⏳ Generate 400+ matching MCP server definitions

  4. ⏳ Bulk load into database

  5. ⏳ Stress test pagination with 400+ items

  6. ⏳ Optimize database queries for scale

  7. ⏳ Add advanced filtering (by category, provider, tags)

  8. ⏳ Add bulk operations (enable/disable multiple)

Success Criteria:

Deliverables:

  • all_credential_types_400.py - Complete n8n credential types

  • mcp_servers_library_400.json - 400+ MCP servers

  • Advanced pagination component

  • Enhanced search/filter system

  • Performance optimization report

  • Comprehensive documentation

Timeline: 20-30 hours (3-4 days)


Part 2: Phase 1 Implementation Details (30 Servers)

2.1 The 30 MCP Server Library

Matching Our 30 Credential Types:

Total: 30 MCP Servers across 9 categories, perfectly matched to our 30 credential types!


2.2 Auto-Activation System

How It Works:

Trigger Point:


2.3 Pagination Implementation

Backend: API Pagination

Frontend: Pagination Component

Update Tools Dashboard with Pagination

Update Credentials Tab with Pagination


2.4 Database Bulk Load Script


Part 3: Phase 2 Implementation (400+ Servers)

3.1 Credential Scraping Strategy

Source: https://github.com/n8n-io/n8n/tree/master/packages/nodes-base/credentials

Approach:

3.2 MCP Server Generation

For each credential type, generate corresponding MCP server:

3.3 Advanced Search & Filtering


Part 4: Testing Plan

Phase 1 Testing (30 Servers)

Test 1: Load MCP Servers

Test 2: Pagination

Test 3: Auto-Activation

Test 4: Search & Filter

Test 5: Agent Tool Assignment

Test 6: End-to-End Workflow


Phase 2 Testing (400+ Servers)

Performance Tests:

Search Performance:


Part 5: Database Optimization for Scale

5.1 Indexes for Performance

5.2 Query Optimization


Part 6: UI Enhancements

6.1 Bulk Operations

6.2 Category Stats Dashboard


Part 7: Success Metrics

Phase 1 Success Criteria (30 Servers)

Phase 2 Success Criteria (400+ Servers)


Part 8: Timeline

Phase 1: Week 1 (8-12 hours)

Day 1 (4-6h):

  • ✅ Create mcp_servers_library_30.json

  • ✅ Create load_mcp_servers.py script

  • ✅ Implement auto-activation service

  • ✅ Load 30 servers into database

  • ✅ Test auto-activation

Day 2 (4-6h):

  • ✅ Add pagination to backend APIs

  • ✅ Create Pagination component

  • ✅ Update Tools Dashboard with pagination

  • ✅ Update Credentials Tab with pagination

  • ✅ Test pagination with 30 items

  • ✅ Fix any bugs

  • ✅ Complete end-to-end test


Phase 2: Week 2-3 (20-30 hours)

Week 2 (12-16h):

  • ⏳ Scrape n8n credentials (or manually convert)

  • ⏳ Generate all 400+ credential types

  • ⏳ Generate all 400+ MCP servers

  • ⏳ Add database indexes

  • ⏳ Optimize queries

Week 3 (8-14h):

  • ⏳ Bulk load all 400+ items

  • ⏳ Implement advanced filters

  • ⏳ Add bulk operations

  • ⏳ Performance testing & optimization

  • ⏳ Documentation & demo


Part 9: Files to Create/Modify

Phase 1 Files

New Files:

  1. mcp_servers_library_30.json - 30 MCP server definitions

  2. scripts/load_mcp_servers.py - Bulk loader script

  3. services/mcp_auto_activation.py - Auto-activation service

  4. components/shared/pagination.tsx - Reusable pagination component

  5. PRDS/20-MCP-CREDENTIAL-INTEGRATION.md - This PRD

Modified Files:

  1. api/mcp_tools.py - Add pagination, search, filters

  2. api/credentials.py - Add pagination, trigger auto-activation

  3. components/tools/tools-dashboard.tsx - Add pagination

  4. components/settings/CredentialsTab.tsx - Add pagination

  5. hooks/use-mcp-tools-api.ts - Update to support pagination params

Phase 2 Files

New Files:

  1. credential_types/all_credential_types_400.py - All 400+ types

  2. mcp_servers_library_400.json - All 400+ servers

  3. scripts/scrape_n8n_credentials.py - n8n scraper

  4. scripts/generate_mcp_servers.py - Generator script

  5. components/shared/advanced-filter.tsx - Advanced filtering

  6. components/shared/multi-select.tsx - Multi-select component

  7. components/tools/bulk-operations.tsx - Bulk enable/disable

  8. migrations/add_mcp_performance_indexes.sql - Performance indexes


Part 10: Business Impact

Competitive Advantage

  • 400+ pre-integrated tools vs. competitors' 10-50

  • One-click activation vs. manual configuration

  • Credential-driven UX (add credential → tools appear)

  • Netflix-style marketplace for integrations

User Experience

  • Discovery: Browse 400+ integrations like Netflix

  • Activation: Add credential → instant access

  • Assignment: Drag-drop to agents

  • Execution: Zero configuration needed

Cost Savings

  • Engineering Time: No custom integrations needed

  • Maintenance: n8n community maintains 400+ integrations

  • Support: Standardized credential system

  • Onboarding: Users familiar with n8n patterns

Revenue Potential

  • Premium Integrations: Charge for enterprise tools

  • Usage-Based: Meter tool executions

  • Enterprise Plans: Unlimited integrations

  • Marketplace: Community contributions


Part 11: Risks & Mitigation

Risk
Impact
Mitigation

n8n scraping fails

High

Manual conversion as fallback

Performance degradation

Medium

Indexes, caching, query optimization

UI becomes overwhelming

Medium

Good filters, search, categories

Auto-activation false positives

Low

Explicit credential type matching

Database storage

Low

400 records ≈ 2MB, negligible


Part 12: Post-Implementation

Monitoring

  • Track auto-activation success rate

  • Monitor pagination query performance

  • Measure search latency

  • Track user adoption per integration

Maintenance

  • Weekly: Review new n8n integrations

  • Monthly: Update MCP server library

  • Quarterly: Performance optimization review

  • Yearly: Major version upgrades

Documentation

  • User guide: "How to enable integrations"

  • Developer guide: "Adding new MCP servers"

  • Video tutorial: "From credential to execution in 60 seconds"

  • API docs: All new endpoints


Conclusion

PRD-20 transforms Automatos AI into the most comprehensive AI orchestration platform with:

Phase 1 (THIS WEEK):

  • 30 MCP servers matching 30 credential types

  • Pagination system (ready for 400+)

  • Auto-activation (credential → MCP servers)

  • Complete testing and validation

🚀 Phase 2 (NEXT WEEK):

  • ALL 400+ n8n credential types

  • ALL 400+ matching MCP servers

  • Advanced search and filtering

  • Bulk operations

  • Performance optimization

The Result:

"Users add an AWS credential, and 15 AWS integrations instantly appear. Add GitHub token, get 8 GitHub tools. Add Stripe key, get payment processing. One credential away from ANY integration."

This is the platform differentiator. This is what makes Automatos AI unstoppable. 🔥


Status: Ready for Phase 1 Implementation Timeline: Phase 1: 1-2 days | Phase 2: 3-4 days Priority: P0 - CRITICAL

LET'S FUCKING GO! 🚀🚀🚀

Last updated