Skip to main content
Glama

MCP Person Registration System

by Zeyneptncr
npmGitHub
JavaScript
3
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

👥 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 ekler
    • Güncelle 2 Mehmet Can → günceller
    • Sil 3 → siler
    • Listele → tüm kişileri listeler
  • 🧩 Toollar:
    • create-task-db: yeni kişi ekler
    • list-tasks: tüm kişileri listeler
    • update-task: kişiyi günceller
    • delete-task: kişiyi siler

🏗 Yapı

n8n tarafı:

  • When chat message received → AI Agent → Gemini
  • AI Agent → MCP Tool + PostgreSQL Memory + Simple Memory
  • MCP tool URL: http://host.docker.internal:3000/sse

MCP server (server.js):

  • Express + @modelcontextprotocol/sdk ile SSE tabanlı komut alır
  • Gelen komutları veritabanına işler (tasks tablosu)
  • Gerekirse Google Sheets entegrasyonu eklenebilir

🛠 Kurulum

  1. PostgreSQL sunucusu çalışır durumda olmalı
  2. tasks tablosu şu şekilde olmalı:
CREATE TABLE tasks ( id SERIAL PRIMARY KEY, title TEXT, date DATE );

This server cannot be installed

-
security - not tested
F
license - not found
-
quality - not tested

How are these scores calculated?

A system that manages person records through natural Turkish language commands processed by an AI Agent, connecting to an Express+PostgreSQL MCP server for CRUD operations.

  1. 🚀 Özellikler
    1. 🏗 Yapı
      1. n8n tarafı:
      2. MCP server (server.js):
    2. 🛠 Kurulum

      Related MCP Servers

      • FastPostgresMCP

        llm-graph
        A
        security
        A
        license
        A
        quality
        A blazing fast MCP server that enables AI agents to interact with multiple PostgreSQL databases, providing functionality to list tables, inspect schemas, execute queries, and run transactions.
        Last updated -
        4
        58
        TypeScript
        MIT License

      • FastAPI MCP Server

        texas000
        -
        security
        F
        license
        -
        quality
        A sample FastAPI project that implements the Model Context Protocol (MCP), allowing AI assistants to connect to a PostgreSQL database and manage notes through natural language interactions.
        Last updated -
        Python

      • PostgreSQL API SSH MCP Server

        iMAGRAY
        -
        security
        A
        license
        -
        quality
        A universal MCP server that enables AI agents to securely manage PostgreSQL databases, make API requests, and execute SSH commands with features for database analysis, schema editing, and data operations.
        Last updated -
        JavaScript
        MIT License

      • MCP Chat

        0xAnkitSingh
        -
        security
        F
        license
        -
        quality
        A command-line interface application that enables interactive chat with AI models through the Anthropic API, supporting document retrieval, command-based prompts, and extensible tool integrations.
        Last updated -
        Python
        • Linux
        • Apple

      View all related MCP servers

      New MCP Servers

      MCP directory API

      We provide all the information about MCP servers via our MCP API.

      curl -X GET 'https://glama.ai/api/mcp/v1/servers/Zeyneptncr/MCP'

      If you have feedback or need assistance with the MCP directory API, please join our Discord server