Oracle Code Assist vs Snowflake CoCo

Oracle Code Assist is an AI coding companion for developers working with Java, SuiteScript, PL/SQL, and applications on OCI. It offers code completion, chat assistance, and a coding agent as plugins for JetBrains IntelliJ IDEA and Visual Studio Code. Its listed tasks include generating code and test cases, annotating and explaining code, and analyzing code for bugs or inefficiencies with suggested fixes. Developers can provide parts of a codebase as prompt context, and recommendations can reflect an organization’s code, libraries, policies, and practices. Oracle says the service uses OCI GPUs for inference, temporarily processes prompts and supplied code, and deletes prompts after responding. It says supplied code snippets are not stored and personally identifiable information is not collected; the plugin does collect usage metrics and user feedback. Generated code is scanned for non-permissive licenses. The Java-optimized offering is in limited availability, and beta participation requires an application. Pricing is on request; there is no free plan.

Snowflake CoCo is an AI coding agent for data engineering, analytics, machine learning, and agent-building work in Snowflake. It is available in Snowsight, as desktop software, and through a command-line interface. In Snowsight, it can create SQL and Python notebook code from natural-language requests, explain or optimize queries, and answer account administration questions. Desktop mode offers agent and editor workflows, local repository access, plugins, skills, hooks, MCP connections, and interaction with web pages and Snowflake notebooks. The CLI can connect to Snowflake, execute SQL, access local files, and run bash and git operations. Its security controls include role-based access, OS sandboxing, approval tiers, and automatic risk assessment. CoCo supports code completion, chat assistance, codebase indexing, and terminal access; an Agent Client Protocol preview supports use with Zed, JetBrains, VS Code, and Neovim. Access requires cross-region inference. The 30-day introductory trial includes $40 USD in inference credits, followed by a $20 USD monthly subscription fee; separate Snowflake compute and storage charges may apply. Usage can also be billed by token consumption.