All Free Tools
Data Type Converter
Convert data types between PostgreSQL, MySQL, SQLite, SQL Server, and BigQuery.
→
| Type | PostgreSQL | MySQL |
|---|---|---|
| Integer (small) | SMALLINT | SMALLINT |
| Integer | INTEGER | INT |
| Integer (big) | BIGINT | BIGINT |
| Serial / Auto-increment | SERIAL | INT AUTO_INCREMENT |
| Decimal / Numeric | NUMERIC(p,s) | DECIMAL(p,s) |
| Float | REAL | FLOAT |
| Double | DOUBLE PRECISION | DOUBLE |
| Boolean | BOOLEAN | TINYINT(1) |
| String (fixed) | CHAR(n) | CHAR(n) |
| String (variable) | VARCHAR(n) | VARCHAR(n) |
| Text (unlimited) | TEXT | TEXT / LONGTEXT |
| UUID | UUID | CHAR(36) |
| Date | DATE | DATE |
| Time | TIME | TIME |
| Timestamp | TIMESTAMP | DATETIME |
| Timestamp w/ TZ | TIMESTAMPTZ | TIMESTAMP |
| JSON | JSONB | JSON |
| Binary / Blob | BYTEA | BLOB / LONGBLOB |
| Array | type[] | JSON |
| Enum | CREATE TYPE ... AS ENUM | ENUM('a','b') |
Database Access
Give Your AI Agents
Database Access. Securely.
Connect any database. Control permissions. Audit every query. All running locally on your machine.