{"name":"io.github.marcelo-ochoa/oracle","slug":"marcelo-ochoa-oracle","title":null,"description":"MCP server for interacting with Oracle databases","url":"https://mcp.market/server/marcelo-ochoa-oracle","rating":null,"grade":"B","score":78,"certified":false,"status":"active","category":"other","tags":[],"presence":{"score":25,"stars":2,"forks":0,"downloads_week":106,"last_push_at":"2026-08-21T17:58:48.000Z","license":"NOASSERTION"},"uptime":null,"claimed":false,"transport":"npm","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/marcelo-ochoa/servers","website":null,"version":"1.0.7","remotes":[],"packages":[{"registryType":"npm","identifier":"@marcelo-ochoa/server-oracle","version":"1.0.7","transport":{"type":"stdio"},"packageArguments":[{"description":"Oracle connection string","type":"positional","valueHint":"connectionString"}],"environmentVariables":[{"description":"Oracle user name","format":"string","name":"ORACLE_USER"},{"description":"Oracle password","format":"string","isSecret":true,"name":"ORACLE_PASSWORD"}]}],"tools":[{"name":"orcl-awr","description":"Generate an Automatic Workload Repository (AWR) report or AWR SQL report for Oracle database performance analysis. AWR reports provide comprehensive performance metrics including database statistics, wait events, top SQL statements, system resources, and performance recommendations. If no sql_id is provided, generates a full AWR database report with: - Database instance information and configurati","write_action":false,"price_micros":0,"input_schema":null},{"name":"orcl-connect","description":"Provides an interface to connect to a specified database. If a database connection is already active, prompt the user for confirmation before switching to the new connection. The `model` argument should only be used to specify the name and version of the LLM (Large Language Model) you are using, with no additional information. The `mcp_client` argument should specify only the name of the MCP (Mode","write_action":false,"price_micros":0,"input_schema":null},{"name":"orcl-explain","description":"Generate and display the execution plan for a given SQL query using Oracle's EXPLAIN PLAN command. This tool helps you understand how Oracle will execute your query, including information about table access methods, join operations, indexes used, estimated costs, and cardinality estimates. Args: \\tsql: The SQL query to explain. The `model` argument should specify only the name and version of the L","write_action":false,"price_micros":0,"input_schema":null},{"name":"orcl-query","description":"This tool executes SQL queries in a READY ONLY session connected to an Oracle database. If no active connection exists, it uses MCP server registration argument and environment variables ORACLE_USER and ORACLE_PASSWORD. You should: \\tExecute the provided SQL query. \\tReturn the results in Json format. Args: \\tsql: The SQL query to execute. The `model` argument should specify only the name and vers","write_action":true,"price_micros":0,"input_schema":null},{"name":"orcl-stats","description":"Get comprehensive statistics for a specific Oracle database object (table, index, or view). This tool retrieves detailed information including row counts, block statistics, segment size, index information, column statistics, partition details, and other metadata that can help optimize queries and understand data distribution. Args: \\tname: The name of the database object to get statistics for. The","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":78,"grade":"B","scanned_at":"2026-09-28T06:07:01.256Z","report":{"scannerVersion":"0.1.10","scannedAt":"2026-09-28T06:07:01.192Z","components":{"code":{"score":25,"max":25,"notes":["12 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":12,"max":15,"notes":["last push 38 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"npm","identifier":"@marcelo-ochoa/server-oracle","version":"1.0.7","found":true,"license":"MIT","hasInstallScripts":false,"dependencyCount":3,"publishedAt":"2026-03-11T18:05:09.351Z","repositoryUrl":"git+https://github.com/marcelo-ochoa/servers.git","weeklyDownloads":106}],"repo":{"found":true,"owner":"marcelo-ochoa","repo":"servers","archived":false,"pushedAt":"2026-08-21T17:58:48Z","stars":2,"forks":0,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/16995718?v=4","ownerCreatedAt":"2016-02-01T00:57:08Z","license":"NOASSERTION"},"icon":{"url":"https://avatars.githubusercontent.com/u/16995718?v=4&s=128","source":"github"},"presence":{"stars":2,"forks":0,"downloadsWeek":106,"license":"NOASSERTION","lastPushAt":"2026-08-21T17:58:48.000Z","score":25}}}},"grade_history":[],"reviews":[]}