Hi there, you'd have to be an admin for the workspace you are trying to publish the template from. Could you double check that this is the case?

i deleted these code blocks from Template Overview now it published

## API Reference

### Health Check

```bash

GET /health

```

Response:

```json

{

"status": "healthy",

"database": "connected",

"dataDir": "/app/data",

"timestamp": "2025-01-15T10:00:00.000Z"

}

```

### Execute SQL Query

```bash

POST /query

Content-Type: application/json

{

"query": "SELECT * FROM users WHERE id = $1",

"params": [1]

}

```

Response:

```json

{

"success": true,

"rows": [

{ "id": 1, "name": "John", "email": "john@example.com" }

],

"rowCount": 1,

"fields": [

{ "name": "id", "dataTypeID": 23 },

{ "name": "name", "dataTypeID": 25 }

]

}

```

### Execute Transaction

```bash

POST /transaction

Content-Type: application/json

{

"queries": [

{

"query": "INSERT INTO users (name, email) VALUES ($1, $2)",

"params": ["Alice", "alice@example.com"]

},

{

"query": "UPDATE users SET name = $1 WHERE email = $2",

"params": ["Bob", "bob@example.com"]

}

]

}

```

### List All Tables

```bash

GET /tables

```

Response:

```json

{

"success": true,

"tables": ["users", "posts", "comments"]

}

```

### Get Table Schema

```bash

GET /tables/users/schema

```

Response:

```json

{

"success": true,

"tableName": "users",

"columns": [

{

"column_name": "id",

"data_type": "integer",

"is_nullable": "NO",

"column_default": "nextval('users_id_seq'::regclass)"

}

]

}

```

### Export Database

```bash

GET /export

```

Downloads SQL dump file of entire database.

### Import SQL

```bash

POST /import

Content-Type: application/json

{

"sql": "CREATE TABLE products (id SERIAL, name TEXT);"

}

```

### Database Statistics

```bash

GET /stats

```

Response:

```json

{

"success": true,

"database_size": "8192 bytes",

"tables": [

{

"schemaname": "public",

"tablename": "users",

"size": "16 kB"

}

]

}

```

Great to know