René's URL Explorer Experiment


Title: Types - PowerSync

Open Graph Title: Types - PowerSync

X Title: Types - PowerSync

Description: How Postgres, MongoDB, MySQL, SQL Server and Convex types map to PowerSync's SQLite-based sync column definitions.

Open Graph Description: How Postgres, MongoDB, MySQL, SQL Server and Convex types map to PowerSync's SQLite-based sync column definitions.

X Description: How Postgres, MongoDB, MySQL, SQL Server and Convex types map to PowerSync's SQLite-based sync column definitions.

Opengraph URL: https://docs.powersync.com/sync/types

Generator: Mintlify

direct link

Domain: docs.powersync.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.powersync.com/#organization","name":"PowerSync","url":"https://www.powersync.com","logo":{"@type":"ImageObject","url":"https://docs.powersync.com/images/logo.png"},"sameAs":["https://github.com/powersync-ja","https://x.com/powersync_","https://www.linkedin.com/showcase/journeyapps-powersync/","https://bsky.app/profile/powersync.com"]},{"@type":"WebSite","@id":"https://docs.powersync.com#website","name":"PowerSync","url":"https://docs.powersync.com","publisher":{"@id":"https://www.powersync.com/#organization"}},{"@type":"WebPage","@id":"https://docs.powersync.com/sync/types#webpage","url":"https://docs.powersync.com/sync/types","name":"Types","description":"How Postgres, MongoDB, MySQL, SQL Server and Convex types map to PowerSync's SQLite-based sync column definitions.","dateModified":"2026-10-05T09:11:58.269Z","isPartOf":{"@id":"https://docs.powersync.com#website"},"breadcrumb":{"@id":"https://docs.powersync.com/sync/types#breadcrumb"}},{"@type":"BreadcrumbList","@id":"https://docs.powersync.com/sync/types#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Sync Streams","item":"https://docs.powersync.com/sync/streams/overview"},{"@type":"ListItem","position":2,"name":"Reference","item":"https://docs.powersync.com/sync/supported-sql"},{"@type":"ListItem","position":3,"name":"Types","item":"https://docs.powersync.com/sync/types"}]},{"@type":["Article","TechArticle"],"@id":"https://docs.powersync.com/sync/types#article","headline":"Types","name":"Types","description":"How Postgres, MongoDB, MySQL, SQL Server and Convex types map to PowerSync's SQLite-based sync column definitions.","url":"https://docs.powersync.com/sync/types","mainEntityOfPage":{"@id":"https://docs.powersync.com/sync/types#webpage"},"dateModified":"2026-10-05T09:11:58.269Z","publisher":{"@id":"https://www.powersync.com/#organization"},"isPartOf":{"@id":"https://docs.powersync.com#website"}}]}
{"@context":"https://schema.org","@type":"WebSite","name":"PowerSync","publisher":{"@type":"Organization","name":"PowerSync"},"provider":{"@type":"Organization","name":"Mintlify","url":"https://mintlify.com"}}

application-namePowerSync
og:site_namePowerSync
og:typewebsite
og:imagehttps://powersync.mintlify.site/_mintlify/api/og/v2?division=Reference&title=Types&description=How+Postgres,+MongoDB,+MySQL,+SQL+Server+and+Convex+types+map+to+PowerSync's+SQLite-based+sync+column+definitions.&theme=18174f9f4f4a1da907b109cc&signature=994de3e4bdc66ed5fa4849697b4c4e85d1b2389e394d4e8a4a27b3dc67ed7ee9
og:image:width1200
og:image:height630
twitter:cardsummary_large_image
twitter:imagehttps://powersync.mintlify.site/_mintlify/api/og/v2?division=Reference&title=Types&description=How+Postgres,+MongoDB,+MySQL,+SQL+Server+and+Convex+types+map+to+PowerSync's+SQLite-based+sync+column+definitions.&theme=18174f9f4f4a1da907b109cc&signature=994de3e4bdc66ed5fa4849697b4c4e85d1b2389e394d4e8a4a27b3dc67ed7ee9
twitter:image:width1200
twitter:image:height630
msapplication-config/mintlify-assets/_mintlify/favicons/powersync/dhIUAAc0qIG0PJBM/_generated/favicon/browserconfig.xml
apple-mobile-web-app-titlePowerSync
msapplication-TileColor#4e89ff
og:localeen_US

Links:

/llms.txthttps://docs.powersync.com/llms.txt
Skip to main contenthttps://docs.powersync.com/sync/types#content-area
PowerSync home pagehttps://www.powersync.com/
https://docs.powersync.com/intro/powersync-overview
Dashboardhttps://dashboard.powersync.com/
Get Startedhttps://accounts.powersync.com/portal/powersync-signup?s=docs
Get Startedhttps://accounts.powersync.com/portal/powersync-signup?s=docs
GitHubhttps://github.com/powersync-ja
Community Discordhttps://discord.com/invite/powersync
PowerSync Websitehttps://www.powersync.com/
Introductionhttps://docs.powersync.com/intro/powersync-overview
Setup Guidehttps://docs.powersync.com/intro/setup-guide
Exampleshttps://docs.powersync.com/intro/examples
Self-Hostinghttps://docs.powersync.com/intro/self-hosting
Overviewhttps://docs.powersync.com/sync/streams/overview
Quickstarthttps://docs.powersync.com/sync/streams/quickstart
Supported SQLhttps://docs.powersync.com/sync/supported-sql
Grammar Referencehttps://docs.powersync.com/sync/grammar/sync-streams
Type Mappinghttps://docs.powersync.com/sync/types
Overviewhttps://docs.powersync.com/client-sdks/overview
ORM Supporthttps://docs.powersync.com/client-sdks/orms/overview
Sync Catch-Uphttps://docs.powersync.com/client-sdks/checkpoint-requests
Usage Exampleshttps://docs.powersync.com/client-sdks/usage-examples
Monitoring and Alertinghttps://docs.powersync.com/maintenance-ops/monitoring-and-alerting
Replication Laghttps://docs.powersync.com/maintenance-ops/replication-lag
Production Readiness Best Practiceshttps://docs.powersync.com/maintenance-ops/production-readiness-guide
Compacting Bucketshttps://docs.powersync.com/maintenance-ops/compacting-buckets
Overviewhttps://docs.powersync.com/integrations/overview
Neonhttps://docs.powersync.com/integrations/neon
Serverpodhttps://docs.powersync.com/integrations/serverpod
Overviewhttps://docs.powersync.com/tools/overview
CLIhttps://docs.powersync.com/tools/cli
PowerSync Dashboardhttps://docs.powersync.com/tools/powersync-dashboard
Sync Diagnostics Clienthttps://github.com/powersync-ja/powersync-js/tree/main/tools/diagnostics-app#readme
Local Developmenthttps://docs.powersync.com/tools/local-development
Terraform Providerhttps://docs.powersync.com/tools/terraform
AI Toolshttps://docs.powersync.com/tools/ai-tools
Performance and Limitshttps://docs.powersync.com/resources/performance-and-limits
Supported Platformshttps://docs.powersync.com/resources/supported-platforms
Feature Statushttps://docs.powersync.com/resources/feature-status
FAQhttps://docs.powersync.com/resources/faq
Local-First Softwarehttps://docs.powersync.com/resources/local-first-software
Contact Ushttps://docs.powersync.com/resources/contact-us
https://docs.powersync.com/sync/types#postgres-type-mapping
JSON functions and operatorshttps://docs.powersync.com/sync/supported-sql#operators
Operators & Functionshttps://docs.powersync.com/sync/supported-sql
ST functionshttps://docs.powersync.com/sync/supported-sql#functions
compatibility optionshttps://docs.powersync.com/sync/advanced/compatibility#custom_postgres_types
compatibility optionshttps://docs.powersync.com/sync/advanced/compatibility#custom_postgres_types
compatibility optionshttps://docs.powersync.com/sync/advanced/compatibility#custom_postgres_types
functionshttps://docs.powersync.com/sync/supported-sql#functions
https://docs.powersync.com/sync/types#convex-type-mapping
experimental featurehttps://docs.powersync.com/resources/feature-status
JSON functions and operatorshttps://docs.powersync.com/sync/supported-sql#operators
https://docs.powersync.com/sync/types#mongodb-type-mapping
Operators & Functionshttps://docs.powersync.com/sync/supported-sql
JSON functions and operatorshttps://docs.powersync.com/sync/supported-sql#operators
functionshttps://docs.powersync.com/sync/supported-sql#functions
https://docs.powersync.com/sync/types#mysql-type-mapping
Beta releasehttps://docs.powersync.com/resources/feature-status
functionshttps://docs.powersync.com/sync/supported-sql#functions
https://docs.powersync.com/sync/types#sql-server-type-mapping
Beta releasehttps://docs.powersync.com/resources/feature-status
functionshttps://docs.powersync.com/sync/supported-sql#functions
Suggest editshttps://github.com/powersync-ja/powersync-docs/edit/main/sync/types.mdx
Raise issuehttps://github.com/powersync-ja/powersync-docs/issues/new?title=Issue on docs&body=Path: /sync/types
Grammar ReferencePrevioushttps://docs.powersync.com/sync/grammar/sync-streams
Advanced TopicsNexthttps://docs.powersync.com/sync/advanced/overview
Postgres Type Mappinghttps://docs.powersync.com/sync/types#postgres-type-mapping
Convex Type Mappinghttps://docs.powersync.com/sync/types#convex-type-mapping
MongoDB Type Mappinghttps://docs.powersync.com/sync/types#mongodb-type-mapping
MySQL Type Mappinghttps://docs.powersync.com/sync/types#mysql-type-mapping
SQL Server Type Mappinghttps://docs.powersync.com/sync/types#sql-server-type-mapping
PowerSync home pagehttps://www.powersync.com/
githubhttps://github.com/powersync-ja
discordhttps://discord.com/invite/powersync
blueskyhttps://bsky.app/profile/powersync.com
xhttps://x.com/powersync_
youtubehttps://www.youtube.com/@powersync_
linkedinhttps://www.linkedin.com/showcase/journeyapps-powersync
Release Noteshttps://releases.powersync.com
System Statushttps://status.powersync.com/
Roadmaphttps://roadmap.powersync.com
Bloghttps://www.powersync.com/blog
githubhttps://github.com/powersync-ja
discordhttps://discord.com/invite/powersync
blueskyhttps://bsky.app/profile/powersync.com
xhttps://x.com/powersync_
youtubehttps://www.youtube.com/@powersync_
linkedinhttps://www.linkedin.com/showcase/journeyapps-powersync
Powered byThis documentation is built and hosted on Mintlify, a developer documentation platformhttps://www.mintlify.com?utm_campaign=poweredBy&utm_medium=referral&utm_source=powersync

Viewport: width=device-width, initial-scale=1, viewport-fit=cover


URLs of crawlers that visited me.