MCP Person Registration System
Powers the MCP server that processes SSE-based commands for person record management.
Optional integration that could be added for storing or exporting person records.
Hosts the AI Agent using Gemini 2.5 Flash that interprets natural Turkish language commands for person management operations.
Stores and manages person records in a 'tasks' table, allowing creation, listing, updating, and deletion operations.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
👥 MCP + n8n Kişi Kayıt Sistemi
Bu proje, n8n üzerinde çalışan bir AI Agent ile geliştirilen, kullanıcı mesajlarından kişi kayıtlarını yöneten bir sistemdir. Kayıt işlemleri, Express + PostgreSQL ile yazılmış bir MCP sunucusuna bağlıdır. Komutlar doğal Türkçe dilde verilir.
🚀 Özellikler
🔗 n8n AI Agent → Gemini 2.5 Flash + Simple Memory + PostgreSQL Memory + MCP Tool
🧠 System Message sayesinde Türkçe komutlarla kişi işlemleri yapılır:
Ekle Ahmet Yılmaz→ kişi eklerGüncelle 2 Mehmet Can→ güncellerSil 3→ silerListele→ tüm kişileri listeler
🧩 Toollar:
create-task-db: yeni kişi eklerlist-tasks: tüm kişileri listelerupdate-task: kişiyi güncellerdelete-task: kişiyi siler
Related MCP server: TeacherAssist-MCP
🏗 Yapı
n8n tarafı:
When chat message received→ AI Agent → GeminiAI Agent→ MCP Tool + PostgreSQL Memory + Simple MemoryMCP tool URL:
http://host.docker.internal:3000/sse
MCP server (server.js):
Express +
@modelcontextprotocol/sdkile SSE tabanlı komut alırGelen komutları veritabanına işler (
taskstablosu)Gerekirse Google Sheets entegrasyonu eklenebilir
🛠 Kurulum
PostgreSQL sunucusu çalışır durumda olmalı
taskstablosu şu şekilde olmalı:
CREATE TABLE tasks (
id SERIAL PRIMARY KEY,
title TEXT,
date DATE
);Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Analytical memory for AI agents: a real Postgres queried in plain English over MCP. One command.
Xata MCP server lets AI agents interact with your Xata projects, and Postgres database branches.
Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceAn MCP server enabling AI assistants to perform CRUD operations on a Supabase database via a standardized interface.194MIT
- AlicenseNot gradedqualityDmaintenanceAI-powered Teacher Assistance MCP Server for managing student records with PostgreSQL, enabling create and read operations via MCP tools.MIT
- FlicenseNot gradedqualityDmaintenanceMCP server for managing users in PostgreSQL, enabling CRUD operations and search via natural language commands.-
- FlicenseNot gradedqualityDmaintenanceAI-powered expense tracking MCP server that connects LLM clients to PostgreSQL for natural language expense management.-