{"id":"oracle-oci-postgresql-mcp-server","name":"oracle.oci-postgresql-mcp-server","homepage":"https://pypi.org/project/oracle.oci-postgresql-mcp-server/","repo_url":null,"category":"databases","subcategories":[],"tags":["oracle","oci","postgresql","database","mcp-server","cloud","managed-database","infrastructure"],"what_it_does":"Provides an MCP server interface for managing Oracle OCI PostgreSQL databases, enabling programmatic control over database instances, queries, backups, and configurations.","use_cases":["Automated database provisioning and scaling in OCI","Running SQL queries and monitoring database health","Managing backups, restores, and disaster recovery","Integrating database operations into AI agent workflows","Database administration and maintenance automation"],"not_for":["Multi-cloud database management across AWS, GCP, and OCI","Non-relational or NoSQL database workloads"],"best_when":"You are building agents or automation within Oracle Cloud Infrastructure that need to manage PostgreSQL databases programmatically.","avoid_when":"You need cross-cloud database abstraction or are committed to non-OCI cloud providers.","alternatives":["AWS RDS for PostgreSQL with boto3","Google Cloud SQL for PostgreSQL with client libraries","Self-hosted PostgreSQL with direct psycopg2 connections"],"af_score":72.8,"security_score":90.1,"reliability_score":79.5,"package_type":"mcp_server","discovery_source":["pypi"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T22:38:33.973064+00:00","interface":{"has_rest_api":true,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":null,"has_sdk":true,"sdk_languages":["Python","Java","Go","TypeScript"],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["API Key","IAM Roles","Instance Principal"],"oauth":false,"scopes":true,"notes":"Uses Oracle Cloud IAM for authentication and authorization; supports multiple credential types for flexibility."},"pricing":{"model":"Pay-as-you-go","free_tier_exists":true,"free_tier_limits":null,"paid_tiers":["Standard (hourly billing)","Enterprise (committed capacity)"],"requires_credit_card":true,"estimated_workload_costs":null,"notes":"Oracle Cloud free tier includes limited PostgreSQL database resources; pricing scales with instance size and storage."},"requirements":{"requires_signup":true,"requires_credit_card":true,"domain_verification":false,"data_residency":["US","EU","Canada","APAC","Japan"],"compliance":["SOC 2 Type II","ISO 27001","FedRAMP","HIPAA","GDPR"],"min_contract":null},"agent_readiness":{"af_score":72.8,"security_score":90.1,"reliability_score":79.5,"mcp_server_quality":78.0,"documentation_accuracy":76.0,"error_message_quality":null,"error_message_notes":null,"auth_complexity":65.0,"rate_limit_clarity":68.0,"tls_enforcement":95.0,"auth_strength":92.0,"scope_granularity":88.0,"dependency_hygiene":82.0,"secret_handling":91.0,"security_notes":"Oracle Cloud IAM provides strong access controls; TLS enforced for all connections; secrets management integrated with OCI Vault.","uptime_documented":88.0,"version_stability":80.0,"breaking_changes_history":74.0,"error_recovery":76.0,"idempotency_support":"true","idempotency_notes":"OCI API operations are idempotent; safe for retry logic in agent workflows.","pagination_style":"offset-based with configurable page size","retry_guidance_documented":true,"known_agent_gotchas":["Rate limiting enforced per-tenancy; agents must implement backoff","IAM permission model is granular and complex; authorization failures are common in early testing","Connection pooling critical for high-concurrency agent scenarios; default limits can be exceeded"]}}