mcp-server
by ngotruong09
Overview
Provides two distinct services: a file writer for local storage and a comprehensive Oracle database management tool, allowing for data querying and manipulation.
Installation
python src/file_server.pyEnvironment Variables
- ORACLE_USER
- ORACLE_PASSWORD
- ORACLE_DSN
Security Notes
CRITICAL: The Oracle DB server (`src/oracle_server.py`) is highly vulnerable to SQL injection. All database interaction tools (`query_data`, `insert_data`, `update_data`, `delete_data`, `inspect_table`, `inspect_package`, `inspect_procedure`) construct SQL queries by directly concatenating user-provided input via f-strings. This allows an attacker to execute arbitrary SQL commands by injecting malicious code into parameters such as `sql`, `table`, `columns`, `values`, `set_clause`, `where_clause`, `table_name`, `package_name`, or `procedure_name`. This could lead to unauthorized data access, modification, deletion, or even database compromise. The file server (`src/file_server.py`) uses `os.path.basename` to sanitize filenames, which is good for preventing directory traversal attacks. However, it allows writing arbitrary content to files without validation, which could be misused to store malicious scripts or fill up disk space. No hardcoded secrets were found as database credentials are sourced from environment variables.
Similar Servers
mcp
This repository provides a collection of Model Context Protocol (MCP) servers to enable AI agents to interact with and manage various Oracle Cloud Infrastructure (OCI) services, Oracle Database, and MySQL databases through natural language.
tiger-cli
Tiger CLI provides a Model Context Protocol (MCP) server that enables AI assistants to interact with Tiger Cloud database services, manage service lifecycles, execute SQL queries, and access documentation via proxied tools.
mcp-maintainer-toolkit
This server provides a Model Context Protocol (MCP) interface with various tools and resources designed to assist in maintaining, testing, and developing MCP repositories and clients.
mcp-filesystem-python
A Python-based filesystem MCP Agent designed to perform user-requested file and directory operations with a focus on security and resource limits.