Skip to main content
Version: 0.0.25

Table: service

Table to manage AWS ECS services. You can use an Amazon ECS service to run and maintain a specified number of instances of a task definition simultaneously in an Amazon ECS cluster. If one of your tasks fails or stops, the Amazon ECS service scheduler launches another instance of your task definition to replace it. This helps maintain your desired number of tasks in the service.


INSERT INTO service ("name", desired_count, subnets, assign_public_ip, cluster_id, task_definition_id, target_group_id)
VALUES ('service_name', 1, (select array(select subnet_id from subnet inner join vpc on = subnet.vpc_id where is_default = true and vpc.region = 'us-east-1' limit 3)),
'ENABLED', (SELECT id FROM cluster WHERE cluster_name = '${clusterName}'), (select id from task_definition where family = 'task-definition' and region = 'us-east-1'
order by revision desc limit 1), (SELECT id FROM target_group WHERE target_group_name = 'target-group' and region = 'us-east-1'));

SELECT * FROM service WHERE name = 'service-name';

DELETE FROM service WHERE name = 'service-name';



Optional arn: string

AWS ARN for the service

assign_public_ip: assign_public_ip

Whether to assign a public IP to the service

Optional cluster: cluster

Reference to the cluster where the service belongs to

Optional desired_count: number

The desired number of instantiations of the task definition to keep running on the service.

name: string

Name of the container definition

region: string

Region for the ECS service

security_groups: security_group[]

Reference to all the security groups used by the service


Optional status: string

Current status of the service

subnets: string[]

Ids of all the VPC subnets used by the service


Optional target_group: target_group

Reference of the target group that will be associated with the service, to expose it via load balancers


Optional task: task_definition

Reference to the task definition that uses the service