Released greenative.mcp, MCP server for AI and Data Integration

Avgidea has released greenative.mcp, a Model Context Protocol (MCP ) compliant component. This allows Claude Desktop and other generative AI to connect to various databases and storage via the Avgidea Data Platform (ADP), making it easy to retrieve and update data and configure flexible data sources.

greenative.mcp usage from Claude Desktop

greenative.mcp features

greenative.mcp is an MCP server that acts as a bridge between the generative AI (AI agent) and corporate data. This allows the generative AI to retrieve and update data without directly manipulating the company's data.

• A single MCP Server can access multiple databases and object storage via ADP.

• No separate database/storage drivers or libraries are required on the client side, and ADP runs as a single binary file with a footprint of only a few MB.

• Only necessary data can be exposed to users by adding or removing data sources on the ADP side. No configuration changes are required on the client terminal side, allowing for flexible data management when managing a large number of client PCs.

• Even without knowledge of SQL, the generative AI can create SQL statements using natural language queries, and extract and update data from the database via ADP. In addition, data can be saved as CSV files on the local PC by using other MCP Servers.

• After receiving SQL requests, ADP queries the database using the appropriate driver.

• It supports AWS and Google Cloud database and storage services to support data integration and operations in a multi-cloud environment.

  
  
  
  

  This video shows a series of operations to retrieve and aggregate data in natural language from Claude Desktop via greenative.mcp.

  
  

  Use cases

  Automatic generation of management reports

  When management asks in natural language, “I want to check sales this month and how they compare to the same month last year,” Claude Desktop reads the intent and automatically generates the necessary SQL statements. greenative.mcp can query multiple databases via ADP to obtain sales aggregate reports. This makes reporting work more efficient and real-time, which was conventionally handled individually by analysts.

  
  

  Promoting Data Utilization by Business Departments

  Even users with no knowledge of SQL can extract the necessary data, save it in CSV format, and use it by asking questions in natural language, such as “I want to know the effect of a campaign by prefecture” or “I want to check the monthly sales number of a specific product. It provides an environment where each department can utilize data autonomously without the need to operate advanced BI tools or request the data team.

  
  

  Data Catalog Search

  When planning a new product or conducting market analysis, you can extract product master information (product name, model number, category, price, etc.) on ADP by asking questions in natural language in response to needs such as “I want to check the price range for each product category” or “I want to list specifications by model number”. This allows product planning and marketing departments to quickly grasp the necessary information, improving operational speed and supporting efficient decision-making.

  
  
  
  

  Deploying ADP

  ADP is available as a SaaS/PaaS environment operated by Avgidea, or as a dedicated instance deployed in a public cloud environment owned by a company or organization.

  
  

  In the case of dedicated instances, Avgidea will directly maintain and operate them. Customization is possible according to the security policy and operational requirements of each company, and the system can be flexibly integrated with in-house systems.