René's URL Explorer Experiment


Title: How to run a database migration when using SQLModel (such as Alembic)? · Issue #85 · fastapi/sqlmodel · GitHub

Open Graph Title: How to run a database migration when using SQLModel (such as Alembic)? · Issue #85 · fastapi/sqlmodel

X Title: How to run a database migration when using SQLModel (such as Alembic)? · Issue #85 · fastapi/sqlmodel

Description: First Check I added a very descriptive title to this issue. I used the GitHub search to find a similar issue and didn't find it. I searched the SQLModel documentation, with the integrated search. I already searched in Google "How to X in...

Open Graph Description: First Check I added a very descriptive title to this issue. I used the GitHub search to find a similar issue and didn't find it. I searched the SQLModel documentation, with the integrated search. I...

X Description: First Check I added a very descriptive title to this issue. I used the GitHub search to find a similar issue and didn't find it. I searched the SQLModel documentation, with the integrated searc...

Opengraph URL: https://github.com/fastapi/sqlmodel/issues/85

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"How to run a database migration when using SQLModel (such as Alembic)?","articleBody":"### First Check\r\n\r\n- [X] I added a very descriptive title to this issue.\r\n- [X] I used the GitHub search to find a similar issue and didn't find it.\r\n- [X] I searched the SQLModel documentation, with the integrated search.\r\n- [X] I already searched in Google \"How to X in SQLModel\" and didn't find any information.\r\n- [X] I already read and followed all the tutorial in the docs and didn't find an answer.\r\n- [X] I already checked if it is not related to SQLModel but to [Pydantic](https://github.com/samuelcolvin/pydantic).\r\n- [X] I already checked if it is not related to SQLModel but to [SQLAlchemy](https://github.com/sqlalchemy/sqlalchemy).\r\n\r\n### Commit to Help\r\n\r\n- [X] I commit to help with one of those options 👆\r\n\r\n### Example Code\r\n\r\nI created a simple app (based on the documentation using FastAPI and SQLModel)\r\nThis can be run with either Docker or a python virtual environment, to speed things up. \r\n\r\nhttps://github.com/joemudryk/learning-sqlmodel\r\n\r\n\r\n\r\n### Description\r\n\r\nI am trying to:\r\n1. Create a database from the existing model\r\n2. Update the model (or uncomment [this line](https://github.com/joemudryk/learning-sqlmodel/blob/83a6734a69c93d396b395a2849eb0cc7f34a6166/models/hero.py#L10) )\r\n3. Run a database migration such as Alembic\r\n4. Continue to use the application with the updated model and database\r\n\r\nAny help would be greatly appreciated, and maybe the instructions can be used to help update the [official documentation](https://sqlmodel.tiangolo.com/advanced/?h=migration)  :) \r\n\r\n### Operating System\r\n\r\nLinux\r\n\r\n### Operating System Details\r\n\r\nLinux Mint 20.1\r\n\r\n### SQLModel Version\r\n\r\n0.0.4\r\n\r\n### Python Version\r\n\r\n3.9.6\r\n\r\n### Additional Context\r\n\r\nI was able to use [Alembic](https://alembic.sqlalchemy.org/en/latest/) for the orm library [ormar](https://collerek.github.io/ormar/) okay. The instructions for that can be found here:\r\nhttps://collerek.github.io/ormar/models/migrations/\r\n\r\nMaybe that will give some insight for the approach I took, or you will find a solution that I didn't.\r\n\r\nThank you in advanced.","author":{"url":"https://github.com/joemudryk","@type":"Person","name":"joemudryk"},"datePublished":"2021-09-08T04:29:15Z","url":"https://github.com/fastapi/sqlmodel/issues/85"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:44c627af-c2c7-cf26-3d2b-171eb0b3d123
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-id96B4:580A9:7A469:AEB96:6AFDEE8E
html-safe-nonce46f7fa508e1613282f152884b09aa3eb58c0b967422b5ac97a3b950521526f66
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5NkI0OjU4MEE5OjdBNDY5OkFFQjk2OjZBRkRFRThFIiwidmlzaXRvcl9pZCI6IjQ3MTE1NDY0MzIyMTU5Njk0MjIiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac7b30955f1a4167d82abd6c7ffb7277e1a1424c7d9ba08a11a0f23b4406d6fe90
hovercard-subject-tagissue:990702413
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/fastapi/sqlmodel/85/issue_layout
twitter:imagehttps://opengraph.githubassets.com/7acb38c529a8dcde9f49229e22d6d007bef48d6fb71a88da8f4ecaa51691a6da/fastapi/sqlmodel/issues/85
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/7acb38c529a8dcde9f49229e22d6d007bef48d6fb71a88da8f4ecaa51691a6da/fastapi/sqlmodel/issues/85
og:image:altFirst Check I added a very descriptive title to this issue. I used the GitHub search to find a similar issue and didn't find it. I searched the SQLModel documentation, with the integrated search. I...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamejoemudryk
hostnamegithub.com
expected-hostnamegithub.com
Nonedd812ec581ecac95855f5ec917ef9827506c39a9da1443f43ddb4179a46471eb
turbo-cache-controlno-preview
go-importgithub.com/fastapi/sqlmodel git https://github.com/fastapi/sqlmodel.git
octolytics-dimension-user_id156354296
octolytics-dimension-user_loginfastapi
octolytics-dimension-repository_id399495186
octolytics-dimension-repository_nwofastapi/sqlmodel
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id399495186
octolytics-dimension-repository_network_root_nwofastapi/sqlmodel
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release32ac708bac264dafdc28e10ff49b4d137f0c34a7
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/fastapi/sqlmodel/issues/85#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffastapi%2Fsqlmodel%2Fissues%2F85
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffastapi%2Fsqlmodel%2Fissues%2F85
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=fastapi%2Fsqlmodel
Reloadhttps://github.com/fastapi/sqlmodel/issues/85
Reloadhttps://github.com/fastapi/sqlmodel/issues/85
Reloadhttps://github.com/fastapi/sqlmodel/issues/85
fastapihttps://github.com/fastapi
sqlmodelhttps://github.com/fastapi/sqlmodel
Codehttps://github.com/fastapi/sqlmodel
Issues1 (1)https://github.com/fastapi/sqlmodel/issues
Pull requests53 (53)https://github.com/fastapi/sqlmodel/pulls
Discussionshttps://github.com/fastapi/sqlmodel/discussions
Actionshttps://github.com/fastapi/sqlmodel/actions
Projectshttps://github.com/fastapi/sqlmodel/projects
Security and qualityhttps://github.com/fastapi/sqlmodel/security
Insightshttps://github.com/fastapi/sqlmodel/insights
https://github.com/fastapi/sqlmodel
New issuehttps://github.com/login?return_to=https://github.com/fastapi/sqlmodel/issues/85
New issuehttps://github.com/login?return_to=https://github.com/fastapi/sqlmodel/issues/85
How to run a database migration when using SQLModel (such as Alembic)?https://github.com/fastapi/sqlmodel/issues/85#top
questionFurther information is requestedhttps://github.com/fastapi/sqlmodel/issues?q=state%3Aopen%20label%3A%22question%22
https://github.com/joemudryk
joemudrykhttps://github.com/joemudryk
on Sep 8, 2021https://github.com/fastapi/sqlmodel/issues/85#issue-990702413
Pydantichttps://github.com/samuelcolvin/pydantic
SQLAlchemyhttps://github.com/sqlalchemy/sqlalchemy
https://github.com/joemudryk/learning-sqlmodelhttps://github.com/joemudryk/learning-sqlmodel
this linehttps://github.com/joemudryk/learning-sqlmodel/blob/83a6734a69c93d396b395a2849eb0cc7f34a6166/models/hero.py#L10
official documentationhttps://sqlmodel.tiangolo.com/advanced/?h=migration
Alembichttps://alembic.sqlalchemy.org/en/latest/
ormarhttps://collerek.github.io/ormar/
https://collerek.github.io/ormar/models/migrations/https://collerek.github.io/ormar/models/migrations/
joemudrykhttps://github.com/joemudryk
questionFurther information is requestedhttps://github.com/fastapi/sqlmodel/issues?q=state%3Aopen%20label%3A%22question%22
on Sep 8, 2021https://github.com/fastapi/sqlmodel/issues/85#event-5269547936
https://github.com/mjhea0
mjhea0https://github.com/mjhea0
on Sep 8, 2021https://github.com/fastapi/sqlmodel/issues/85#issuecomment-915641233
@joemudrykhttps://github.com/joemudryk
https://github.com/testdrivenio/fastapi-sqlmodel-alembichttps://github.com/testdrivenio/fastapi-sqlmodel-alembic
https://github.com/artemkalugin01
artemkalugin01https://github.com/artemkalugin01
on Sep 9, 2021https://github.com/fastapi/sqlmodel/issues/85#issuecomment-916035291
@joemudrykhttps://github.com/joemudryk
https://stackoverflow.com/questions/68932099/how-to-get-alembic-to-recognise-sqlmodel-database-modelhttps://stackoverflow.com/questions/68932099/how-to-get-alembic-to-recognise-sqlmodel-database-model
https://github.com/joemudryk
joemudrykhttps://github.com/joemudryk
on Sep 10, 2021https://github.com/fastapi/sqlmodel/issues/85#issuecomment-917228849
@mjhea0https://github.com/mjhea0
@artemkalugin01https://github.com/artemkalugin01
this is a good async examplehttps://github.com/testdrivenio/fastapi-sqlmodel-alembic
joemudrykhttps://github.com/joemudryk
completedhttps://github.com/fastapi/sqlmodel/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Sep 10, 2021https://github.com/fastapi/sqlmodel/issues/85#event-5286657066
https://github.com/sheyzi
sheyzihttps://github.com/sheyzi
on Sep 14, 2021https://github.com/fastapi/sqlmodel/issues/85#issuecomment-919078036
@joemudrykhttps://github.com/joemudryk
https://github.com/sheyzi
sheyzihttps://github.com/sheyzi
on Sep 14, 2021https://github.com/fastapi/sqlmodel/issues/85#issuecomment-919095197
https://github.com/thebleucheese
thebleucheesehttps://github.com/thebleucheese
on Dec 12, 2021https://github.com/fastapi/sqlmodel/issues/85#issuecomment-991955596
#11https://github.com/fastapi/sqlmodel/pull/11
bbelderboshttps://github.com/bbelderbos
on Dec 23, 2021https://github.com/fastapi/sqlmodel/issues/85#event-5808890569
added alembichttps://github.com/bbelderbos/codeimag.es/commit/cf61c478f99ea0dcd4455fb3ddce776994ac0b53
cf61c47https://github.com/bbelderbos/codeimag.es/commit/cf61c478f99ea0dcd4455fb3ddce776994ac0b53
tddschnhttps://github.com/tddschn
on May 29, 2022https://github.com/fastapi/sqlmodel/issues/85#event-6697798459
add alembic confighttps://github.com/tddschn/todo-cli-tddschn/commit/2f213b627be0720e40858e0c501eed1282b64e61
2f213b6https://github.com/tddschn/todo-cli-tddschn/commit/2f213b627be0720e40858e0c501eed1282b64e61
https://github.com/abreumatheus
abreumatheushttps://github.com/abreumatheus
on Sep 12, 2022https://github.com/fastapi/sqlmodel/issues/85#issuecomment-1244427008
@joemudrykhttps://github.com/joemudryk
@tiangolohttps://github.com/tiangolo
tiangolohttps://github.com/tiangolo
on Nov 20, 2022https://github.com/fastapi/sqlmodel/issues/85#event-7851952190
tiangolohttps://github.com/tiangolo
completedhttps://github.com/fastapi/sqlmodel/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Nov 20, 2022https://github.com/fastapi/sqlmodel/issues/85#event-7851952416
https://github.com/tiangolo
tiangolohttps://github.com/tiangolo
on Nov 20, 2022https://github.com/fastapi/sqlmodel/issues/85#issuecomment-1321205851
@joemudrykhttps://github.com/joemudryk
https://github.com/dncastilho
dncastilhohttps://github.com/dncastilho
on Jan 12, 2023https://github.com/fastapi/sqlmodel/issues/85#issuecomment-1380418653
https://github.com/luiz-floresdelima
luiz-floresdelimahttps://github.com/luiz-floresdelima
on Jul 8, 2023https://github.com/fastapi/sqlmodel/issues/85#issuecomment-1627230408
@joemudrykhttps://github.com/joemudryk
https://github.com/testdrivenio/fastapi-sqlmodel-alembichttps://github.com/testdrivenio/fastapi-sqlmodel-alembic
@joemudrykhttps://github.com/joemudryk
good tutorialhttps://testdriven.io/blog/fastapi-sqlmodel/
https://github.com/ruslaniv
ruslanivhttps://github.com/ruslaniv
on Apr 5, 2024https://github.com/fastapi/sqlmodel/issues/85#issuecomment-2039315195
https://github.com/robinelvin
robinelvinhttps://github.com/robinelvin
on Apr 6, 2024https://github.com/fastapi/sqlmodel/issues/85#issuecomment-2041137520
https://github.com/0x054
0x054https://github.com/0x054
on Apr 7, 2024https://github.com/fastapi/sqlmodel/issues/85#issuecomment-2041614472
@ruslanivhttps://github.com/ruslaniv
https://github.com/joemudryk
joemudrykhttps://github.com/joemudryk
on Apr 9, 2024https://github.com/fastapi/sqlmodel/issues/85#issuecomment-2045996220
@tiangolohttps://github.com/tiangolo
advanced docs on SQLModelhttps://sqlmodel.tiangolo.com/advanced/
https://github.com/20-buck-spin
20-buck-spinhttps://github.com/20-buck-spin
on May 23, 2024https://github.com/fastapi/sqlmodel/issues/85#issuecomment-2126494680
https://github.com/zhanymkanov/fastapi-best-practiceshttps://github.com/zhanymkanov/fastapi-best-practices
https://github.com/moon548834
moon548834https://github.com/moon548834
on Jul 9, 2024https://github.com/fastapi/sqlmodel/issues/85#issuecomment-2216322577
https://github.com/eulersson
eulerssonhttps://github.com/eulersson
on Aug 22, 2025https://github.com/fastapi/sqlmodel/issues/85#issuecomment-3215091308
FastAPI & Alembic - Database Migrations in FastAPI appshttps://www.youtube.com/watch?v=zTSmvUVbk8M
https://github.com/KSmanis
KSmanishttps://github.com/KSmanis
on Sep 22, 2025https://github.com/fastapi/sqlmodel/issues/85#issuecomment-3318867561
https://github.com/ParsaJR
ParsaJRhttps://github.com/ParsaJR
on Feb 11, 2026https://github.com/fastapi/sqlmodel/issues/85#issuecomment-3883512315
Sign up for freehttps://github.com/signup?return_to=https://github.com/fastapi/sqlmodel/issues/85
Sign in to commenthttps://github.com/login?return_to=https://github.com/fastapi/sqlmodel/issues/85
questionFurther information is requestedhttps://github.com/fastapi/sqlmodel/issues?q=state%3Aopen%20label%3A%22question%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.