> ## Documentation Index
> Fetch the complete documentation index at: https://docs.apinizer.com/llms.txt
> Use this file to discover all available pages before exploring further.

# API Creator

> API Creator (API Creator), the component in the Apinizer platform that enables instant API creation from databases, scripts, or mock APIs without writing code. It has three main modules: DB-2-API (creating APIs from databases), Script-2-API (creating APIs from JavaScript/Groovy scripts), and Mock API Creator (creating mock APIs). It enables rapid API creation through form-based interfaces.

## API Creator Concept

<CardGroup cols={2}>
  <Card title="DB-2-API" icon="database">
    Creating APIs from databases

    Creating endpoints from SQL queries, calling stored procedures, and batch operations.
  </Card>

  <Card title="Script-2-API" icon="code">
    Creating APIs from scripts

    Exposing JavaScript or Groovy code as APIs.
  </Card>

  <Card title="Mock API Creator" icon="wand-magic-sparkles">
    Creating mock APIs

    Instantly creating mock APIs without any server or code writing needs.
  </Card>

  <Card title="Instant Creation" icon="bolt">
    On-the-fly API creation

    Instantly creating and publishing APIs without requiring additional server setup.
  </Card>
</CardGroup>

## DB-2-API

### DB-2-API Features

<AccordionGroup>
  <Accordion title="SQL Endpoint Creation">
    * Creating endpoints from SQL queries
    * SELECT, INSERT, UPDATE, DELETE support
    * Calling stored procedures
    * Returning cursor results
  </Accordion>

  <Accordion title="Database Support">
    * MySQL
    * PostgreSQL
    * Oracle
    * MSSQL
    * DB2
    * Other JDBC-supported databases
  </Accordion>

  <Accordion title="Batch Operations">
    * Bulk data processing
    * Transaction support
    * Error handling
  </Accordion>
</AccordionGroup>

### DB-2-API Usage Scenarios

<CardGroup cols={3}>
  <Card title="Rapid Prototyping" icon="bolt">
    Rapid API creation from database

    Instantly creating API prototypes without writing code.
  </Card>

  <Card title="Legacy System Integration" icon="arrows-rotate">
    Converting legacy databases to APIs

    Converting existing databases to modern APIs.
  </Card>

  <Card title="Microservice Creation" icon="sitemap">
    Exposing database operations as services

    Publishing database operations as microservices.
  </Card>
</CardGroup>

## Script-2-API

### Script-2-API Features

<CardGroup cols={2}>
  <Card title="JavaScript Support" icon="js">
    * Running JavaScript code
    * Node.js-like environment
  </Card>

  <Card title="Groovy Support" icon="code">
    * Groovy script support
    * Java integration
  </Card>

  <Card title="Message Access" icon="file-lines">
    * Request/Response access
    * Header access
    * Body manipulation
  </Card>

  <Card title="External API Calls" icon="plug">
    * HTTP client
    * Database connection
    * Other API calls
  </Card>
</CardGroup>

### Script-2-API Usage Scenarios

<CardGroup cols={3}>
  <Card title="Custom Logic" icon="code">
    APIs containing custom business logic

    APIs with custom logic using JavaScript/Groovy.
  </Card>

  <Card title="Data Transformation" icon="arrows-rotate">
    Data transformation APIs

    Data format conversion and processing APIs.
  </Card>

  <Card title="Business Logic" icon="briefcase">
    Business logic APIs

    APIs containing business rules and logic.
  </Card>
</CardGroup>

## Mock API Creator

### Mock API Creator Features

<AccordionGroup>
  <Accordion title="Mock Response Creation">
    * Sample responses
    * Schema-based response
    * Custom responses
  </Accordion>

  <Accordion title="Scenario Management">
    * Different responses for different scenarios
    * Error scenarios
    * Success scenarios
  </Accordion>

  <Accordion title="Dynamic Response">
    * Variable responses
    * Random data generation
    * Conditional response
  </Accordion>
</AccordionGroup>

### Mock API Creator Usage Scenarios

<CardGroup cols={3}>
  <Card title="Frontend Development" icon="code">
    Frontend development without backend ready

    Starting frontend development before backend development is completed.
  </Card>

  <Card title="API Design" icon="pencil">
    Testing API design

    Testing and validating API design with mock API.
  </Card>

  <Card title="Integration Testing" icon="flask">
    Integration tests

    Using mock API in integration tests.
  </Card>
</CardGroup>

## API Creator Advantages

<CardGroup cols={2}>
  <Card title="Rapid Development" icon="bolt">
    * Rapid API creation without writing code
    * APIs ready for instant use
  </Card>

  <Card title="Easy to Use" icon="wand-magic-sparkles">
    * Form-based interface
    * Minimal configuration
  </Card>

  <Card title="Flexibility" icon="puzzle-piece">
    * Creating APIs from various sources
    * Customizable endpoints
  </Card>

  <Card title="Integration" icon="plug">
    * Integration with existing systems
    * Integration with API Gateway
  </Card>
</CardGroup>

## API Creator and API Gateway Relationship

APIs created with API Creator are automatically published through API Gateway. Workflow:

```
API Creator
   │
   │ API Creation
   │ (DB-2-API / Script-2-API / Mock API)
   │
   ▼
API Gateway
   │
   │ Automatic Publishing
   │ Traffic Management
   │
   ▼
Client Requests
```

<CardGroup cols={3}>
  <Card title="1. API Creation" icon="plus-circle">
    Creating API with API Creator

    Creating DB-2-API, Script-2-API, or Mock API.
  </Card>

  <Card title="2. Automatic Publishing" icon="rocket">
    Automatic publishing through API Gateway

    Created APIs are automatically added to gateway.
  </Card>

  <Card title="3. Traffic Management" icon="route">
    API Gateway traffic management

    Security, rate limiting, and routing are applied.
  </Card>
</CardGroup>

<Info>
  APIs created with API Creator automatically benefit from all API Gateway features (security, rate limiting, monitoring, analytics).
</Info>

## Next Steps

<CardGroup cols={2}>
  <Card title="DB-2-API" icon="database" href="/en/develop/api-proxy-creation/api-creator-db-api-creation">
    DB-2-API usage guide
  </Card>

  <Card title="Script-2-API" icon="code" href="/en/develop/api-proxy-creation/api-creator-script-api-creation">
    Script-2-API usage guide
  </Card>

  <Card title="Mock API Creator" icon="wand-magic-sparkles" href="/en/develop/api-proxy-creation/api-creator-mock-api-creation">
    Mock API Creator usage guide
  </Card>

  <Card title="API Integrator" icon="diagram-project" href="/en/concepts/core-components/api-integrator">
    Learn about API Integrator component
  </Card>
</CardGroup>
