home / mcp / zeyneptncr mcp server
Express-based MCP server that processes Turkish commands to manage a PostgreSQL-backed person list via n8n integration.
Configuration
View docs{
"mcpServers": {
"zeyneptncr-mcp": {
"url": "http://host.docker.internal:3000/sse"
}
}
}This MCP server is an Express-based backend that accepts Turkish natural language commands to manage a list of people stored in PostgreSQL. It connects to an MCP client via Server-Sent Events and provides tools to add, update, delete, and list person records through simple, conversational commands.
You interact with the MCP server through your MCP client by sending Turkish phrases. Use the following command patterns to manage person records: Ekle Ahmet Yılmaz adds a person, Güncelle 2 Mehmet Can updates the person with ID 2, Sil 3 deletes the person with ID 3, and Listele returns all records. The system processes these commands, updates the PostgreSQL database, and returns results to you through the MCP client. The MCP tool URL for real-time command processing is http://host.docker.internal:3000/sse.
Key capabilities you can rely on include creating new records, listing all records, updating existing ones, and removing records. The underlying data lives in a table named tasks with fields for an identifier, a title, and a date. This design enables straightforward querying and management of people entries.
Prerequisites you need before starting: a PostgreSQL server that is accessible from the MCP server, and Node.js installed on the machine that will run the MCP server.
Step-by-step setup commands you should run in order:
# 1. Install Node.js (if not already installed)
# Use your platform's package manager or Node.js installer
# Example for Debian/Ubuntu:
# curl -fsSL https://deb.nodesource.com/setup_lts.x | bash -
# apt-get install -y nodejs
# 2. Install PostgreSQL and create a database (if not already running)
# Start PostgreSQL and create a database named mcpdb
# psql -U postgres -c "CREATE DATABASE mcpdb;"
# 3. Create the required table in PostgreSQL
psql -d mcpdb -c """
CREATE TABLE tasks (
id SERIAL PRIMARY KEY,
title TEXT,
date DATE
);
""";
# 4. Install MCP server dependencies
npm install
# 5. Run the MCP server
node server.js
```
Notes
- The server will listen for commands via SSE and apply changes to the `tasks` table as commands arrive. Ensure your PostgreSQL credentials and connection are configured if you customize the server. If you have a different database name or host, adjust the connection accordingly.Configuration and usage details emphasize a clean separation between the MCP client and the backend. The MCP server handles incoming commands, translates them into database operations on the tasks table, and returns results back through the SSE channel. You may extend the setup with Google Sheets integration in the future if needed.
Security considerations include ensuring that the database is accessible only to trusted hosts, validating Turkish commands, and guarding the MCP service against unauthorized access. Regularly update dependencies and monitor the SSE channel for any anomalies.
If you see command processing delays, verify that PostgreSQL is running and reachable from the MCP server host. Check the server logs for any errors related to database connections or query execution. For issues with the SSE connection, ensure the URL http://host.docker.internal:3000/sse is reachable from your MCP client network.
- create-task-db: adds a new person record to the database - list-tasks: lists all person records - update-task: updates an existing person record - delete-task: deletes a person record by identifier
Adds a new person record to the database using a structured insert operation.
Retrieves and returns all person records from the tasks table.
Updates an existing person record by ID with new values.
Removes a person record by its ID from the database.