redd-archiver
Verified Safeby 19-84
Overview
Archiving and providing AI-optimized access to Reddit-like platform data via a PostgreSQL-backed system and a RESTful API.
Installation
uv run python mcp_server/server.py --api-url http://localhost:5000Environment Variables
- POSTGRES_DB
- POSTGRES_USER
- POSTGRES_PASSWORD
- DATABASE_URL
- FLASK_SECRET_KEY
- REDDARCHIVER_SITE_NAME
- REDDARCHIVER_API_URL
Security Notes
The project implements rate limiting, CSRF protection, and parameterized queries for SQL injection prevention within its API. Input validation regex whitelists are used to sanitize user input. Docker containers for core services are configured with read-only filesystems. Wildcard CORS is explicitly enabled for the public archive API. Peripheral 'tools' use 'sudo docker exec psql' which requires elevated Docker privileges but is not part of the continuously running server. The 'POSTGRES_PASSWORD' in `docker-compose.yml` defaults to 'CHANGE_THIS_PASSWORD' and requires user modification for security.
Similar Servers
MCP-PostgreSQL-Ops
The MCP server provides professional operations, monitoring, and management capabilities for PostgreSQL databases using natural language queries.
dx-mcp-server
Empowers AI applications to interact with and query a user-provided Postgres database via the Model Context Protocol (MCP).
mcp-framework-server
A Python-based server for a Model Context Protocol (MCP) enabling interactive career orientation (proforientation) dialogues via a REST API, designed to integrate with a Telegram bot.
postgresql-mcp-server
Manage and interact with a PostgreSQL database using natural language queries, enabling full DDL, DML, TCL, and backup/restore operations via an AI assistant.