# Schema

## GET /api/v1/schema/{database\_id}/

> List schemas

```json
{"openapi":"3.0.3","info":{"title":"Syntho Backend API","version":"1.0.0 (v1)"},"servers":[{"url":"/"}],"security":[{"authentication":[]},{"OIDC":[]}],"components":{"securitySchemes":{"authentication":{"type":"apiKey","in":"cookie","name":"sessionid","description":"Log in using the <a href='/api/playground/#/Auth/auth_create'>POST /api/v1/auth/</a> endpoint"},"OIDC":{"type":"apiKey","in":"header","name":"Authorization"}},"schemas":{"ListOfSchemas":{"properties":{"schemas":{"items":{"$ref":"#/components/schemas/Schema"},"title":"Schemas","type":"array"},"pagination":{"anyOf":[{"$ref":"#/components/schemas/PaginatedContentSchema"},{"type":"null"}],"default":null}},"required":["schemas"],"title":"ListOfSchemas","type":"object"},"Schema":{"properties":{"name":{"title":"Name","type":"string"},"n_tables":{"title":"N Tables","type":"integer"},"n_views":{"title":"N Views","type":"integer"},"table_start_index":{"title":"Table Start Index","type":"integer"}},"required":["name","n_tables","n_views","table_start_index"],"title":"Schema","type":"object"},"PaginatedContentSchema":{"properties":{"total_elements":{"title":"Total Elements","type":"integer"},"total_pages":{"title":"Total Pages","type":"integer"},"current_page":{"title":"Current Page","type":"integer"},"returned_elements":{"title":"Returned Elements","type":"integer"},"is_last_page":{"title":"Is Last Page","type":"boolean"}},"required":["total_elements","total_pages","current_page","returned_elements","is_last_page"],"title":"PaginatedContentSchema","type":"object"}}},"paths":{"/api/v1/schema/{database_id}/":{"get":{"operationId":"schema_retrieve","description":"List schemas","parameters":[{"in":"query","name":"column_keyword","schema":{"type":"string"}},{"in":"path","name":"database_id","schema":{"type":"string"},"required":true},{"in":"query","name":"elements_per_page","schema":{"type":"integer"}},{"in":"query","name":"requested_page","schema":{"type":"integer"}},{"in":"query","name":"table_keyword","schema":{"type":"string"}}],"tags":["Schema"],"responses":{"200":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/ListOfSchemas"}}},"description":"Success: List of schemas"},"503":{"description":"Message: unable to fetch database from external service"}}}}}}
```