# PostGraphile vs Strawberry GraphQL

**Leader by Vioscale score:** Strawberry GraphQL

| Attribute | PostGraphile | Strawberry GraphQL |
|---|---|---|
| **Vioscale score** | 56 (54% (medium)) | 68.3 (62% (medium)) |
| activity.commits_last_30d | 100 | 28 |
| adoption.dependent_repos | 501 | 325 |
| adoption.github_stars | 12,929 | 4,706 |
| adoption.package_downloads_weekly | 116,682 | 1,579,350 |
| deployment.options | `{"self_hosted":true}` | `{"self_hosted":true}` |
| description.long | An open-source tool that generates GraphQL APIs directly from PostgreSQL databases, with emphasis on performance and customizability. The generated API can be extended and modified to meet specific application needs. | An open-source Python library for constructing GraphQL servers using Python's type hints and dataclasses to define schemas. It provides async support, federation capabilities, real-time subscriptions, and integrations with popular web frameworks. |
| features.capabilities | `{"role":"db_to_graphql","language":"JavaScript/TypeScript","self_hostable":true,"schema_approach":"introspection","type_generation":true,"db_introspection":true}` | `{"role":"server","language":"Python","federation":true,"managed_cloud":false,"self_hostable":true,"subscriptions":true,"auth_directives":true,"schema_approach":"code_first","type_generation":true}` |
| integrations.count | 1 | 10 |
| integrations.list | `[{"name":"PostgreSQL"}]` | `[{"name":"Django"},{"name":"FastAPI"},{"name":"Flask"},{"name":"Aiohttp"},{"name":"Chalice"},{"name":"Channels"},{"name":"Litestar"},{"name":"Quart"},{"name":"Sanic"},{"name":"Starlette"}]` |
| language.primary | TypeScript | Python |
| license.spdx | MIT | MIT |
| market.availability | `{"primaryMarkets":["US"],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | - |
| platform.support | `{"web":true}` | `{"cli":true}` |
| pricing | `{"type":"open_source","plans":[{"free":true,"name":"Core (Open Source)","description":"Self-hosted GraphQL API generation from PostgreSQL","contactSales":false},{"free":false,"name":"On-Demand Consultancy","components":[{"kind":"one_time","amount":375,"currency":"USD"}],"description":"One hour of voice/screensharing with maintainer","contactSales":false},{"free":false,"name":"Development Support","components":[{"kind":"fixed","amount":999,"period":"month","currency":"USD"}],"description":"One-to-one access to Graphile team throughout the year; priority support via chat","contactSales":true}],"summary":"Open source and free. Professional support from $999/month.","freeTier":true,"sourceUrl":"https://www.graphile.org/postgraphile/","retrievedAt":"2026-08-14T16:37:12.955Z","startingPrice":{"amount":375,"period":"month","currency":"USD"}}` | `{"type":"open_source","freeTier":true,"sourceUrl":"https://strawberry.rocks","retrievedAt":"2026-08-14T21:31:32.715Z"}` |
| pricing.free_tier | yes | yes |
| pricing.model | open_source | commercial |
| pricing.price_level | free | free |
| pricing.transparent | yes | yes |
| release.cadence_days | - | 1 |
| release.history | `[{"url":"https://github.com/graphile/crystal/releases/tag/postgraphile%405.1.4","date":"2026-08-05T13:36:30Z","type":"stable","version":"postgraphile@5.1.4"},{"url":"https://github.com/graphile/crystal/releases/tag/grafast%401.1.2","date":"2026-08-05T13:36:32Z","type":"stable","version":"grafast@1.1.2"},{"url":"https://github.com/graphile/crystal/releases/tag/postgraphile%405.1.3","date":"2026-08-04T07:44:26Z","type":"stable","version":"postgraphile@5.1.3"},{"url":"https://github.com/graphile/crystal/releases/tag/graphile-build-pg%405.1.3","date":"2026-08-04T07:44:29Z","type":"stable","version":"graphile-build-pg@5.1.3"},{"url":"https://github.com/graphile/crystal/releases/tag/grafast%401.1.1","date":"2026-08-04T07:44:32Z","type":"stable","version":"grafast@1.1.1"},{"url":"https://github.com/graphile/crystal/releases/tag/postgraphile%405.1.2","date":"2026-07-29T07:07:04Z","type":"stable","version":"postgraphile@5.1.2"},{"url":"https://github.com/graphile/crystal/releases/tag/graphile-build%405.1.1","date":"2026-07-29T07:07:01Z","type":"stable","version":"graphile-build@5.1.1"},{"url":"https://github.com/graphile/crystal/releases/tag/graphile-build-pg%405.1.2","date":"2026-07-29T07:07:07Z","type":"stable","version":"graphile-build-pg@5.1.2"},{"url":"https://github.com/graphile/crystal/releases/tag/postgraphile%405.1.1","date":"2026-07-22T10:38:15Z","type":"stable","version":"postgraphile@5.1.1"},{"url":"https://github.com/graphile/crystal/releases/tag/graphile-utils%405.0.3","date":"2026-07-22T10:38:12Z","type":"stable","version":"graphile-utils@5.0.3"},{"url":"https://github.com/graphile/crystal/releases/tag/graphile-build-pg%405.1.1","date":"2026-07-22T10:38:09Z","type":"stable","version":"graphile-build-pg@5.1.1"},{"url":"https://github.com/graphile/crystal/releases/tag/%40dataplan/pg%401.1.1","date":"2026-07-22T10:38:06Z","type":"stable","version":"@dataplan/pg@1.1.1"},{"url":"https://github.com/graphile/crystal/releases/tag/ruru%402.0.1","date":"2026-07-13T14:39:46Z","type":"stable","version":"ruru@2.0.1"},{"url":"https://github.com/graphile/crystal/releases/tag/postgraphile%405.1.0","date":"2026-07-13T14:39:40Z","type":"stable","version":"postgraphile@5.1.0"},{"url":"https://github.com/graphile/crystal/releases/tag/pgl%405.0.1","date":"2026-07-13T14:40:13Z","type":"stable","version":"pgl@5.0.1"},{"url":"https://github.com/graphile/crystal/releases/tag/graphile%405.1.0","date":"2026-07-13T14:39:58Z","type":"stable","version":"graphile@5.1.0"},{"url":"https://github.com/graphile/crystal/releases/tag/graphile-utils%405.0.2","date":"2026-07-13T14:40:07Z","type":"stable","version":"graphile-utils@5.0.2"},{"url":"https://github.com/graphile/crystal/releases/tag/graphile-config%401.1.0","date":"2026-07-13T14:39:37Z","type":"stable","version":"graphile-config@1.1.0"},{"url":"https://github.com/graphile/crystal/releases/tag/graphile-build%405.1.0","date":"2026-07-13T14:40:10Z","type":"stable","version":"graphile-build@5.1.0"},{"url":"https://github.com/graphile/crystal/releases/tag/graphile-build-pg%405.1.0","date":"2026-07-13T14:39:55Z","type":"stable","version":"graphile-build-pg@5.1.0"}]` | `[{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.324.0","date":"2026-08-10T15:05:53Z","type":"stable","version":"0.324.0"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.323.2","date":"2026-07-23T21:59:24Z","type":"stable","version":"0.323.2"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.323.1","date":"2026-07-22T20:39:02Z","type":"stable","version":"0.323.1"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.323.0","date":"2026-07-21T23:01:26Z","type":"stable","version":"0.323.0"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.322.2","date":"2026-07-20T20:47:08Z","type":"stable","version":"0.322.2"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.322.1","date":"2026-07-20T19:30:27Z","type":"stable","version":"0.322.1"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.322.0","date":"2026-07-18T10:36:20Z","type":"stable","version":"0.322.0"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.321.1","date":"2026-07-17T18:37:31Z","type":"stable","version":"0.321.1"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.321.0","date":"2026-07-13T20:56:10Z","type":"stable","version":"0.321.0"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.320.4","date":"2026-07-09T09:30:06Z","type":"stable","version":"0.320.4"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.320.3","date":"2026-07-07T18:40:58Z","type":"stable","version":"0.320.3"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.320.2","date":"2026-07-06T10:32:15Z","type":"stable","version":"0.320.2"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.320.1","date":"2026-07-02T10:58:21Z","type":"stable","version":"0.320.1"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.320.0","date":"2026-06-27T23:11:50Z","type":"stable","version":"0.320.0"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.319.0","date":"2026-06-21T14:57:45Z","type":"stable","version":"0.319.0"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.318.1","date":"2026-06-20T09:38:11Z","type":"stable","version":"0.318.1"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.318.0","date":"2026-06-19T20:39:34Z","type":"stable","version":"0.318.0"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.317.2","date":"2026-06-17T17:54:23Z","type":"stable","version":"0.317.2"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.317.1","date":"2026-06-17T09:28:43Z","type":"stable","version":"0.317.1"},{"url":"https://github.com/strawberry-graphql/strawberry/releases/tag/0.317.0","date":"2026-06-17T09:22:40Z","type":"stable","version":"0.317.0"}]` |
| reliability.status_page | yes | - |
| security.scorecard | - | 7 |
| security.vulnerabilities | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=npm&package_name=pg-sql2&per_page=100","last_12m":0,"max_severity":null}` | `{"count":7,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=pypi&package_name=strawberry-graphql&per_page=100","last_12m":5,"max_severity":"HIGH"}` |

## Capabilities (GraphQL Tools)

| Capability | PostGraphile | Strawberry GraphQL |
|---|:--:|:--:|
| **Core** |  |  |
| Role | DB-to-GraphQL | Server |
| Primary language | JavaScript/TypeScript | Python |
| **Modelling** |  |  |
| Schema approach | DB introspection | Code-first |
| **Scale** |  |  |
| Federation / subgraph composition | - | ✓ |
| **Realtime** |  |  |
| Real-time subscriptions | - | ✓ |
| **Performance** |  |  |
| Response / edge caching | - | - |
| **DX** |  |  |
| Typed code generation | ✓ | ✓ |
| **Automation** |  |  |
| Generates API from a database | ✓ | - |
| **Security** |  |  |
| Built-in authz / permissions | - | ✓ |
| **Deployment** |  |  |
| Official hosted offering | - | ✗ |
| Self-hostable | ✓ | ✓ |

*Source: Vioscale. Generated 2026-09-01T16:48:19.884Z. "-" = undocumented, not absent.*
