项目作品/宿务科尔多瓦旅游CMS

Next.js 16React 19TypeScriptTailwind CSS v4Prisma ORMPostgreSQLModel Context Protocol (MCP)Framer MotionCloudflare R2DockerTraefik

宿务科尔多瓦旅游CMS

live · maintained

语言版本：

基于Next.js 16打造的旅游与商业投资平台,具备实时热度分析和内置AI MCP服务器。

访问网站 ↗

cordova.humfurie.org

Cover

为菲律宾宿务科尔多瓦打造的高性能市政门户与无头CMS。具备电影感的3D环绕英雄区、动态"Popular Now"热度引擎、自动化SEO元数据生成,以及用于自主AI管理的内置Model Context Protocol(MCP)服务器。

Featured Engineering & Architecture

How the Hardest Problems Were Solved

Key architectural decisions, concrete code implementations, and performance wins behind this project.

Architectureapp/api/mcp/route.ts

Embedded Model Context Protocol (MCP) Server with Edge-Compatible HTTP Transport & JWT Auth

The Challenge

Exposing internal CMS operations (business listings, blog posts, media uploads, trending analytics, and hero settings) directly to external AI agents and LLM tooling without building redundant REST endpoints or compromising Next.js App Router security.

The Architectural Solution

Implemented an embedded Streamable HTTP MCP server inside the Next.js Route Handler using @modelcontextprotocol/sdk, securing all incoming AI agent operations with stateless JWT verification via jose and modular domain toolkits.

Impact:Consolidated 6 administrative domains into a standardized agent-accessible protocol interface, enabling zero-friction AI assistant workflows with sub-10ms stateless auth overhead.

app/api/mcp/route.ts

async function handleMcpRequest(request: NextRequest): Promise<Response> {

if (!(await isAuthorized(request))) return unauthorized();

const server = createMcpServer();

const transport = new WebStandardStreamableHTTPServerTransport({

sessionIdGenerator: undefined,

});

await server.connect(transport);

return transport.handleRequest(request);

}

Discuss this snippet (app/api/mcp/route.ts)

Backendlib/trending.ts

Cascading Real-Time Trending Engine with ISR Cache Layers

The Challenge

Calculating real-time 'Popular Now' content rankings from raw PageView timeseries telemetry without bottlenecking the database or serving stale/empty results during low-traffic windows.

The Architectural Solution

Built an aggregation engine in lib/trending.ts that groups page views by customizable time windows, falls back smoothly across cascading intervals (1h → 1d → 1w → all-time), and caches computed rankings via Next.js unstable_cache with interval-specific TTLs.

Impact:Reduced database aggregation query frequency by over 95% while guaranteeing zero empty trending widgets through fallback cascading.

Seolib/seo.ts

Universal Dynamic Schema.org & OpenGraph Metadata Generator

The Challenge

Maintaining rich search previews and Schema.org structured data (TouristDestination, LocalBusiness, Article, BreadcrumbList) dynamically across multi-tenant routes with varying fallbacks and strict search engine compliance.

The Architectural Solution

Created a centralized builder utility in lib/seo.ts that produces typed OpenGraph, Twitter cards, and Schema.org graphs for business listings, municipal attractions, and editorial content.

Impact:Achieved 100% Schema.org valid JSON-LD across all dynamic listing and editorial pages with automated canonical link resolution.

// community_discussion

Architecture Feedback & Questions

Have thoughts, questions, or ideas regarding this system's architecture? Leave a comment below with your GitHub account.