api-mcp-server

ambadasjagtap2021/api-mcp-server

3.1

If you are the rightful owner of api-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

The mLogica Star*M MCP Server provides access to mLogica's Star*M database modernization service, facilitating schema analysis, SQL conversion, and migration estimation.

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�
�
�