AI导哈

数据库迁移服务

mLogica Star*M MCP Server 是一款提供数据库现代化服务的工具，支持模式分析、SQL转换和迁移估算，适用于从传统数据库迁移到现代数据库的场景。

  • by ambadasjagtap2021
  • Dockerfile
  • 本地部署
  • 更新于
在 GitHub 查看 ambadasjagtap2021/api-mcp-server

使用说明

mLogica Star*M MCP Server

MCP server providing access to mLogica's Star*M database modernization service.

Features

  • Schema Analysis: Analyze legacy database schemas and get modernization recommendations
  • SQL Conversion: Convert SQL queries and stored procedures between database platforms
  • Migration Estimation: Get complexity, timeline, and cost estimates for migrations

Supported Databases

Source: Teradata, Netezza, Oracle, DB2, Sybase Target: PostgreSQL, MySQL, Aurora PostgreSQL, Redshift

Installation

npm install -g @mlogica/starm-mcp-server
``` {data-source-line="510"}

## Configuration

Add to your MCP client configuration (e.g., Claude Desktop):

```json
{
  "mcpServers": {
    "mlogica-starm": {
      "command": "npx",
      "args": ["-y", "@mlogica/starm-mcp-server"],
      "env": {
        "MLOGICA_API_KEY": "your_api_key_here",
        "MLOGICA_API_ENDPOINT": "https://api.mlogica.com/starm/v1",
        "MLOGICA_TIMEOUT_MS": "300000"
      }
    }
  }
}
``` {data-source-line="530"}

## Getting an API Key

1. **Free Tier**: Sign up at https://mlogica.com/starm/signup
   - Limited conversions per month
   - Basic schema analysis
   - Standard SQL conversion

2. **Paid Tier**: Subscribe at https://mlogica.com/pricing
   - Unlimited conversions
   - Advanced optimization suggestions
   - Priority support
   - Custom migration plans

## Usage Examples

### Analyze Schema
Analyze this Teradata schema for migration to PostgreSQL:
[paste DDL here]
### Convert SQL
Convert this Oracle stored procedure to Aurora PostgreSQL:
[paste SQL here]
### Estimate Migration
Estimate migration for a 500GB Netezza database with 1200 objects to Redshift
## Tier Comparison

| Feature | Free | Paid |
|---------|------|------|
| Schema Analysis | ✅ | ✅ |
| SQL Conversion | ✅ (10/month) | ✅ (Unlimited) |
| Migration Estimates | ✅ | ✅ |
| Performance Optimization | ❌ | ✅ |
| Custom Recommendations | ❌ | ✅ |
| Priority Support | ❌ | ✅ |

## License

MIT

#� �a�p�i�-�m�c�p�-�s�e�r�v�e�r�
�
�

相关 MCP